Excel 2016 - VBE editor toolbar and menus missing

Question

_{Friday, November 18, 2016 1:32 PM}

After opening an Excel file from a colleague which seemed to have errors with the VBA code contained in it. I have subsequently lost the VBE menu bar and menus from the VBE editor after I click Alt+F11 of select the VBA editor from the Developer toolbar.

I have tried closing all workbooks and reopening, closing office and reopening, rebooting my PC and in-installing and reinstalling Office completely.

I am using Windows 10 and Excel 16, does anyone have a method of resetting the menus back to their default 'visible' condition?

I have raised this with Microsoft support and have been told as a personal user support for this is not covered. Support is covered by a separate team for commercial users only and without a support contract this will cost me £199 to solve!!

Thanks in advance

All replies (1)

_{Monday, November 21, 2016 8:18 AM}

Hi Cheeky,

What's your detailed Excel 2016 version? If you are using the Office 2016 for the Click-to-run version, please download it from Microsoft website to reinstall it:

https://support.office.com/en-us/article/Download-and-install-or-reinstall-Office-365-or-Office-2016-on-your-PC-or-Mac-4414eaaf-0478-48be-9c42-23adc4716658?ui=en-US&rs=en-US&ad=US

Generally, the manual download from Office 365 will install the latest version of Office application currently for you. Then open your Excel application, go to File > Options > Customize Ribbon, check the Developer to show it in Ribbon. Expand Code under Developer, make sure the Visual Basic Editor is listed:

Then confirm if you can go to Developer tab and click the Visual Basic button.

Regards,

Winnie Liang

Please remember to mark the replies as answers if they help.
If you have feedback for TechNet Subscriber Support, contact [email protected].