VBA Project Explorer not working

Are the UDFs by any chance defined as named ranges? Have a look unde Formulas > Name Manager to rule this out.

Thanks for your reply !
The Name Manager only contains three Print Areas (the workbook contains three worksheets).

Cheers,
Emile.

So presumably the UDFs are not working? Was the worksheet they are on copied from another workbook?

Originally Posted by AliGW

So presumably the UDFs are not working? Was the worksheet they are on copied from another workbook?

The UDFs are actually working, it's just that I can't access their VBA code. Yes I believe the worksheet they are on came from another workbook.

Thanks ever so much Artik. It's almost bedtime here in New Zealand, but I will check this out tomorrow morning

Originally Posted by Artik

You can try the following steps to reset the windows layout manually:

- Close all open instances of Excel.
- Press Windows key + R to open the Run dialog box.
- Type %APPDATA%\Microsoft\Excel and press Enter.
- Locate the file named Excel15.xlb or Excel16.xlb and rename it to Excel15.old or Excel16.old.
- Restart Excel.
A new Excel1x.xlb file will be automatically created with the default settings of the VBA editor bar and windows.

If there is still no improvement, consider whether the 64-bit version of Office is necessary for you. If not, install the 32-bit version.

By the way, uninstalling Office does not guarantee the removal of all "junk" that may affect the next installation of the suite. Some Registry entries still remain. You need to use a tool to remove unnecessary entries in the Registry.

Artik

Many thanks again for your suggestions.
I renamed the file Excel15.xlb, then restarted Excel. Problem remained.
I then uninstalled MS Office altogether using Microsoft's SaRA and removed all Office related keys in the registry that I could find.
Re-installed Office 2019 32 bit from my Microsoft account.
Unfortunately, I still can't get VBA Project Explorer to open.
I have spent hours on this to no avail, so I'm going to have to give up

Originally Posted by Artik

I sympathize, you are really very unlucky. You can do the uninstallation of Office with SaRA. But cleaning the registry should be done with a specialized tool. You are unlikely to be able to remove all the right keys yourself. There are many programs for cleaning the Registry, and probably the best known is CCleaner. Registry cleaning should be done after uninstalling Office and rebooting the system.
Before you get desperate and throw your computer away, try putting Windows back up. But such an installation from scratch, nothing by shortcuts.

Artik

Hi Artik, after reading your post I did another uninstall with MSSaRA, reboot, then ran CCleaner, another reboot, then re-installed 32 bit Office again. Unfortunately the issue persists. Many thanks for your advice. Starting from scratch with Windows 10 is not an option for me at this stage.

Do you have the project explorer set to dock under Tools - Options on the Docking tab in the VBE?