Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 69
  • Last Modified:

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
0
MarkH12518
Asked:
MarkH12518
  • 5
  • 4
1 Solution
 
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
 
Roy CoxGroup Finance ManagerCommented:
Have you checked in the View menu in the VB Edito?
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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
 
Roy CoxGroup 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
 
MarkH12518Author Commented:
Thanks for your help.
0
 
Roy CoxGroup Finance ManagerCommented:
Pleased to help. Hope you have found a solution.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now