Visual Basic Project Window won't open in Excel

[Steve Jack]

Until recently I could open the VB Project Manager and edit the code in userforms I had created for Excel. Now when I click on the 'Developer' tab and select 'Visual Basic' I get a new menu that says: 'File, Edit, View, Insert, Format, Debug, Run, Tools, Add-ins, Window'. None of those options opens the Project Manager window. I've checked the Trust Center and Access is enabled. Any ideas would be appreciated.

SVJ

[Winon]

Hello Steve Jack,

Welcome with your first post on this Forum!

Ind the VBE screen, Click on the View Tab, and select "Project Explorer". There you go!

Regards.

[Steve Jack]

I think that is the problem. I can't open the VBE screen.

[Steve Jack]

OK. Tried that in Excel and all it did was adjust my screen brightness. I also tried Alt-FN-F11 which didn't do anything.

[Winon]

That is very strange!

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Steve Jack]

Thanks, Winon! Finally got the VBE to open by expanding the menu that was giving me all the trouble. I don't know why that worked, but it did.

[Winon]

While in Excel on any Sheet hold down Alt and press F11,
That should do it.

Please let me know if it helped.

[Winon]

That is good news,Steve Jack,

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Thanks.