search

rubberduck-vba / Rubberduck

Every programmer needs a rubberduck. COM add-in for the VBA & VB6 IDE (VBE).
https://rubberduckvba.com
GNU General Public License v3.0
1.92k stars 302 forks source link

Excel 2016 Visual Basic button grayed out after RD crashing #3822

Closed jmditner closed 6 years ago

jmditner commented 6 years ago

I downloaded the latest RD version (v2.1.1) and wanted to check the new functionalities. After some tests on existing code, RD crashed.

I then restarted Excel but discovered the VBA IDE button was grayed out. Even ALT + F11 didn't work anymore. What a panic !

After some search I found out that restarting the computer gave access again to VBA. I had no choice to deactivate RD to be able to work again on my VBA code.

I guess this issue comes from Excel 2016, I never had this type of issue on previous Excel versions.

Vogel612 commented 6 years ago

Could you please check for me whether setting the LoadBehaviour of the Addin to 0 in the registry under HKCU\Software\Microsoft\VBA\VBE\6.0\AddIns\Rubberduck.Extension fixes that behavior?

jmditner commented 6 years ago

No it didn't change anything. One thing though, RD does not have to crash to have VBE inactivated. And the deactivation occurs only in VBE for Excel.

image

jmditner commented 6 years ago

Finally the issue really came from my Excel version, now all works fine :smile: Thanks for your help Vogel612