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 301 forks source link

all sub menus for refactoring and indentation are greyed out #5331

Closed mbrillante closed 4 years ago

mbrillante commented 4 years ago

Rubberduck version information The info below can be copy-paste-completed from the first lines of Rubberduck's log or the About box:

Rubberduck version [2.5.0.5244]
Operating System: [Windows 7 Service pack 1 , X64]
Host Product: [Office X86]
Host Version: [16.0.11328.20368]
Host Executable: [Excel]

Description EVen after refreshing the code and the initialization status bar set to ready, all the refactoring and indendation sub menus are greyed out Screenshot1

To Reproduce Steps to reproduce the behavior:

  1. Go to 'VBA code'
  2. Click on 'refresh on status bar'
  3. open rubberduck/indent menu
  4. See sub menus greyed out

Expected behavior Go to 'VBA code'

  1. Click on 'refresh on status bar'
  2. open rubberduck/indent menu
  3. See sub menus should be available to use RubberduckLog.txt

Screenshots If applicable, add screenshots to help explain your problem.

Logfile Rubberduck generates extensive logging in TRACE-Level. If no log was created at %APPDATA%\Rubberduck\Logs, check your settings. Include this log for bug reports about the behavior of Rubberduck.

Additional context Add any other context about the problem here.

retailcoder commented 4 years ago

Thanks for reporting the issue! Are the indenter commands also disabled in the code pane context menu?

mbrillante commented 4 years ago

yes I am afraid

Screenshot2

retailcoder commented 4 years ago

Ok, just looked at the logs - looks like a COM registration issue. This could be caused by a broken Office install, for example if you are running side-by-side different versions of Office that weren't installed in chronological order (e.g. installed Office 2016, then Access 2013)

retailcoder commented 4 years ago

Linking #4955 - are other VBIDE add-ins loaded?

mbrillante commented 4 years ago

Thanks for the very quick response, then there is very little that I can do as my organization does not allow me to fix this. In any case rubberduck is still very helpful to me

mbrillante commented 4 years ago

are other VBIDE add-ins loaded?

No

retailcoder commented 4 years ago

Sorry to hear... on the other hand since side-by-side installs are only officially supported when installed in chronological order, you may have a solid case to get your IT department to repair Office: Rubberduck is being a coalmine canary here - it's very likely other things can break.

bclothier commented 4 years ago

Just to confirm - did you try reinstalling Rubberduck? You should be able to do this using per-user install.

mbrillante commented 4 years ago

Ys I did re-install it per user

mbrillante commented 4 years ago

Ok, just looked at the logs - looks like a COM registration issue. This could be caused by a broken Office install, for example if you are running side-by-side different versions of Office that weren't installed in chronological order (e.g. installed Office 2016, then Access 2013)

Theoretically I should not be allowed to install any software without their permission but I need to do my job properly :-)

bclothier commented 4 years ago

Exactly why we support per-user install. ;-)

mbrillante commented 4 years ago

looking at the installed programs, I have Office 365 before Project and Visio 2016; in betwen there is Office 2003 interop assemblies

retailcoder commented 4 years ago

Unfortunately there isn't much we can do on our end to fix this :(

Since the problem is already reported (linked issue), I'll be closing this one as a duplicate.

Good luck!