Excel Macro Layout 1

[PBAPaul]

I have stupidly managed to completely buggar up (please excuse that technical term) the layout of the macro sheets in my Excel 2010 Workbooks.
I have used the default Excel for layout for so long that I am very used to it. I used to have the Project Explorer Window docked vertically to the left hand side of the area with the Properties window below it. The Macro sheets were then full page and on top of each other.

Is there an easy way to get back to Excel's default layout?

Thank you to anybody that can help.

 

[combo]

VBE is the same for all office applications. You can customise the layout manually, see for instance:

http://www.jkp-ads.com/Articles/VBEDocking.asp

.
If you can edit registry, here is a tip for restoring default settings:

http://www.exceltip.com/general-top...t-positions-using-vba-in-microsoft-excel.html

.


combo

 

[PBAPaul]

The link to restore default settings refers to HKEY_USERS\.Default\Software\Microsoft\VBA\Office.

Unfortunately, my system does not have the reference to VBA. My Registry only shows HKEY_USERS\.Default\Software\Microsoft\Office\Excel or Word etc.

I am running MS Office 2010 in Windows 10.

Any ideas please?

 

[combo]

Search registry for ...\Software\Microsoft\VBA\7.0\Common. It may be in current user settings; VBA key is on the same level as Office key.

combo

 

[PBAPaul]

I found the setting at HK_USERS\S - 1 - 5 .......\Software\Microsoft\VBA\7.0\Common. I renamed the Setting from "Dock" to "OldDock", closed the registry and restarted Excel. JOY! It has reverted to the default.

Thank you very much for your help.