problem with vb editor in excel 2016

I had to install Excel 2016 64 bit and my toolbars on vbeditor has vanished. Please see screenshot. screenshot vbeditor
Anyone have any ideas on how to remedy?

thanks
MarkH12518Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Roy CoxConnect With a Mentor Group Finance ManagerCommented:
Could it be that the VBE Windows and ToolBars have been forced off the screen?

Here's some links that I have found

http://dailydoseofexcel.com/archives/2007/06/21/missing-vbe-toolbars/

https://support.microsoft.com/en-us/kb/829059

This is part of answer I found

Close All Office programs
Open a command prompt and type regedit
Navigate to HKEY_CURRENTUSER\Software\Microsoft\VBA\6.0\Common
Right click on Common and Export to save the *.reg file somewhere safe. This is your back up. Double clicking this file will restore your current settings.
Right click on Common and Delete it. Doing this will remove all of its subkeys that hold your personal settings.
The "Common" key will be recreated the next time you close the VBA Editor along with any changes to the settings you may make.
0
 
Ryan ChongCommented:
is that your machine lack of resources?

one of the methods is simply close your VBA editor and then reopen it again.
0
 
MarkH12518Author Commented:
Machine is a Surface Pro 3, so I think enough resources. I've tried the close and open.

Thanks
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Roy CoxGroup Finance ManagerCommented:
Have you checked in the View menu in the VB Edito?
0
 
MarkH12518Author Commented:
I'm not even getting a view menu in the vb editor, just the screen in my attachment.

Thx
0
 
Roy CoxGroup Finance ManagerCommented:
Have you tried running a repair on Excel?

Do you have the same problem in MS Word?
0
 
MarkH12518Author Commented:
I'm on a Surface Pro 3, and yes I did try to run a repair on office 2016. Both the quick one and the extended one.

Good question on Word. I have the same issue there.

thanks
0
 
Roy CoxGroup Finance ManagerCommented:
It must be an issue with your installation. I've seen mention somewhere about registry entries. I'll see if I can find that.
0
 
MarkH12518Author Commented:
Thanks for your help.
0
 
Roy CoxGroup Finance ManagerCommented:
Pleased to help. Hope you have found a solution.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.