VBA says no open projects (excel)

Hi, Excel&Emojis

That “No Open Projects” view usually means Excel is opening the VBA editor, but Excel is not handing any workbook/VBA project to it. If repair/reinstall did not help, I would not jump straight to wiping Windows, because this can also be caused by a damaged Excel/VBA user profile, startup macro files, add-ins, or broken Office/VBA registry paths.

Here are some suggestions you can try:

First, close Excel completely, then press Win + R and run:

excel /safe

Open a new blank workbook and press Alt + F11. If the workbook appears there, the issue is likely an add-in or startup file. In normal Excel, go to File > Options > Add-ins, disable Excel/COM add-ins, then test again.

Also check the Excel startup folders. Move anything out of these folders temporarily:

%appdata%\Microsoft\Excel\XLSTART

C:\Program Files\Microsoft Office\root\Office16\XLSTART

It is recommended that you also test with a brand-new Windows local user account. If VBA works there, the problem is probably your Windows/Office profile, not the whole OS.

One more thing worth checking: if you ever changed the default Program Files location in the registry or moved Office/VBA components to another drive, set those paths back to the normal C: location, then run Office Online Repair again.

Thank you for your patience in reading, I hope this information has been helpful to you. 

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment."    

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.