Cannot See VBE Code Window

[wsnyder]

Hi all,

Using Excel 365.
I installed an Add-in that one of my users sent me today.
The Add-is was created by another developer for the company prior to me.

Now in another project I was working on, I caanot add a new module - just get a spinning wheel on screen.
I cannot see my code in my existing modules - just a grey screen.

Is there any way to recover?
Even if I have to export all of the modules and import them into a new workbook?

Thanks,
-w

 

[Joe4]

Does closing out of Excel entirely and re-opening it fix the issue?
If not, try uninstalling the Add-In, and see if that corrects it.

 

[wsnyder]

Thanks Joe,

I copied everything from the Addin module into Notepad++
I then disabled all Addins
I then closed all Excel Workbooks
I then opened a new workbook in Excel and saved it as myExcel.xlsm, added a code Module and pasted in the code from the Addin
Saved all and closed out Excel

I then opened myExcel.xlsm and ran it - worked as expected.
I then opened v5 of myprojectfile.xlsm - everything is as expected. I can see all code in all modules.
I then opened v7 of myprojectfile.xlsm. I can see all modules, however, when I click on the modules I cannot see any code in the code window.
The file is 259 KB as expected making me think the code is still in there - I just can't see it. There is only 1 blank sheet in the workbook.

Thanks
-w

 

[wsnyder]

I can click through the modules in the Project Explorer.
The Properties Window updates to show the name of the module, but the code window does not update

I do have a reference to to VBE Extensibility so I can list out modules, subs, and functions, but when v7 is active in Project Explorer, I cannot invoke the Reference Dialog.

Thanks
-w

 

[wsnyder]

I was able to repair the file and get back all code modules.
I followed the instructions in this link from Microsoft Support
-w