VBA Editor – How Can It Be Restored To Original Settings?

[DavidSCowan]

Help please!

I am using Office/Excel 2016. My VBA Editor has got screwed up. The Project Explorer is rammed on top of the Code Window and both are immovable. When trying to view the Properties Window it takes up the whole screen and is immovable. I want to have the original configuration - Project Window to the left with Properties below and the Code window to the right.

Playing around with Tools/Options/Docking doesn’t sort things out.

Searching on the Internet I find a very old “solution” which involves changing a corrupt docking setting in the registry. Unfortunately a search of the Registry reveals that no such setting has the word ‘docking’ in 2016.

This is driving me mad!! Does anyone have a solution?

In hope!

David

 

[Yongle]

How odd that you cannot move them around

Try
- closing every internal window (clicking on the X in the corner) until you have only the main VBA window open
- adding back each required window (one at a time) using View (and then move it if necessary)

 

[DavidSCowan]

Thank you very much for replying. I am afraid i tried that sort of thing - every which way - and it didn't work. I think something got badly corrupted.

It was solved by going to the Registry (Regedit in the search box) then:

HKEY_CURRENT_CURRENT_USER
Software
Microsoft
VBA
7.1 (7.1 is my version of VBA for other people it might be 6.0 or other)
Common (I renamed this Common_old

 

[DavidSCowan]

Thank you very much for replying.

I am afraid i tried that sort of thing - every which way - and it didn't work. I think something got badly corrupted.

In case anyone else has this problem it was solved by:
1) Closing down VBA
2)Going to the Registry (Regedit in the search box) then:

3) HKEY_CURRENT_CURRENT_USER
4) Software
5) Microsoft
6) VBA
7) 7.1 (7.1 is my version of VBA for other people it might be 6.0 or other)
8) Common (I renamed this Common_old)
9) Then restarting VBA which recreates Common

And problem solved - phew!!

Thank again for taking the trouble

David

 

[Yongle]

Thanks for posting the solution - one never knows when one might need these things!!