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.91k stars 299 forks source link

CE doesn't expand Interfaces in Excel when macros are disabled #5094

Open daFreeMan opened 5 years ago

daFreeMan commented 5 years ago

Rubberduck version information Version 2.4.1.4848 OS: Microsoft Windows NT 10.0.15063.0, x64 Host Product: Microsoft Office 2016 x64 Host Version: 16.0.4873.1000 Host Executable: MSACCESS.EXE and Host Executable: EXCEL.EXE

Description In Access, when I click on the "expand" arrow of an Interface in the Code Explorer it expands to show me the members. In Excel, it does not

To Reproduce Steps to reproduce the behavior:

  1. Create an Interface, parse the code
  2. Click on the "expand" arrow next to the interface name in the Code Explorer
  3. See error

Expected behavior It should expand to show members no matter what the host app is.

Screenshots In Access: 2019-08-20 11_27_38-Microsoft Visual Basic for Applications - ROIReport - IWebDownloader (Code)

In Excel: 2019-08-20 11_28_06-Microsoft Visual Basic for Applications - Battleship xlsm design

Logfile RubberduckLog.txt

Additional context Add any other context about the problem here.

daFreeMan commented 5 years ago

Despite having parsed several times, this persisted in Excel. Closing Excel & reopening causes the issue to go away.

Maybe there's something in the logs for posterity to ponder, but... #NoRepo

daFreeMan commented 5 years ago

If macros are disabled in the Excel project, the CE will fail to expand the Interface tree view. If, however, macros are enabled, it will expand just fine.