How to restore VBA Editor to its initial settings?

Question

How to restore the VBA Editor to its intial settings ? I have some troubles with macro and projects explorer windows settings, after some bad manipulations.

RubberDuck · Answer 1 · 2014-11-07T23:06:47.853

20

The only way I know how to accomplish this is to edit the registry.

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.

edited Nov 07 '14 at 23:06

answered Nov 07 '14 at 22:32

RubberDuck

11,933
4
50
95

2

The only key that matters under the `Common` is `Dock`. So only delete the **value** of `Dock` key would be enough. This also works for VBA\7.0 and maybe latter versions – LCFactorization Jun 25 '15 at 23:41
Because that wasn't the question @LCFactorization? The question was how to restore the default settings. I took that to mean *all* of them. – RubberDuck Jun 26 '15 at 00:00
@RubberDuck I've just installed your lovely add-in. If I close configure my vbe windows so I can see your duck-windows it all looks lovely but when I restart Excel it is back the way it was before: is there a way around this? – whytheq Feb 05 '16 at 18:55
Easy-peasy. Worked great. In my particular case, I made a Black Theme that I have to use sometimes and not others. I just saved the .REG file, then reset it and saved another one, then made a batch file to reread them. Clunky but it works. Only catch is in Office 2016 the key is HKEY_CURRENT_USER\Software\Microsoft\VBA\7.1\Common – Wade Hatler Jun 14 '18 at 23:40

score 5 · Answer 2 · edited Jan 13 '21 at 04:34

5

I have the same issue, it's simple:

TOOLS OPTIONS DOCKING

     Then select Object Browser, Project Explorer and that's all.

edited Jan 13 '21 at 04:34

Dharman

30,962
25
85
135

answered Jan 13 '21 at 04:28

Jesus Zavala

51
1
1

score 2 · Answer 3 · edited Jan 31 '21 at 09:04

I had the same problem and realised that if I double click the blue heading of a minimal floating menu, such as the Project-VBAProject menu, it would resize and fit in with the other menus that are expanded. With a bit of moving around and double clicking the headers of the menus that I had selected from the VIEW option, I could get the screen back to the way it originally looked at the default setting of the VBA editor.

Phil

digit6 · Answer 4 · 2018-07-10T01:22:12.057

Solution Using a Mac and Excel 2016.

I found that I could drag the, e.g., project explorer (pe) window toward the edge of the vb window and the outline of the pe window moves and adjusts once you get close enough to the edge. This also works with the other windows as you bring them into view.

My default view is project explorer upper left, properties lower left. To return these to be in that order, drag the one to that location (which will fill that whole area) then drag the other one right on top of that one. That stacks them in the same column and then you can adjust their size within those locations.

score 1 · Answer 5 · answered May 12 '19 at 19:10

I had this same issue and fought with it for literally 2 days. Finally figured it out!!! xD First close the Project Explorer and the Properties windows using the X at the top right. Then go to Options under the Docking tab. Uncheck all boxes. Close the options window and if desired check to see that everything is undocked. Now go back to Options>Docking and check all the boxes you had checked (default is all but object browser). Your windows should have returned to default.

score 1 · Answer 6 · edited Jan 20 '23 at 00:38

I had all menus and windows missing, like no "File", no "Edit", no "View", etc.

Here's what I did:

Closed Excel
Opened the Registry Editor
Navigated to HKEY_CURRENTUSER\Software\Microsoft\VBA
Right clicked on VBA and renamed to VBA_old
Closed the Registry Editor
Opened Excel
Opened Visual Basic

…and voila, VBA was back to normal!

After that, I:

Reopened the Registry Editor and saw that VBA had been recreated
Deleted VBA_old

score 0 · Answer 7 · answered Jul 02 '19 at 09:07

This may not solve the OPs original question of "default" for all, but in my case and possibly others I was looking to re-dock the "Project Explorer" and have modules pop up next to it like default. I'm not sure about other settings, but this is how I restored the above behavior.

In the project explorer right click and select "Dockable". Then insert a module and maximize it. This should restore what I consider default behavior.

score 0 · Answer 8 · answered Feb 02 '21 at 19:10

Actually, it is very easy. You just have to go to View Tab then Click on the Project Explorer & Properties Window. It worked for me because I lost these two and now I got it by doing this. I hope so you will get the same result as well. View the image for more clarity.

score 0 · Answer 9 · answered May 17 '21 at 12:24

Simple steps. Works for Mac , maybe windows too

Close all the tabs in the VBE
View --> Code . This will occupy entire space
After that ,view --> project explorer. this will pop up a tab, drag that tab to the top left corner. It auto fills into a small column which you can drag according to your preference .
Now select view --> properties window and drag the tab to bottom left.

Additional step ( if you use locals window )

Select locals window from view and drag it to the bottom.

score 0 · Answer 10 · answered Nov 03 '21 at 08:54

0

Right click any of the window you want to move and click "Dockable". This should allow you to move all the windows as you want and place them as you wish.

answered Nov 03 '21 at 08:54

Don Nalaka

129
1
11

score -1 · Answer 11 · answered Nov 07 '14 at 21:46

-1

I'm not aware of a 'reset' command but the starting point would be to go to the View menu and start by setting the Code, Project Explorer and Properties windows and then the Toolbars>Standard (toolbar) perhaps?

answered Nov 07 '14 at 21:46

barryleajo

1,956
2
12
13

Visual Studio provides 'Reset Window Layout' in the 'Window' menu, a very useful feature indeed. Why VBA cannot do the same is beyond me to understand - a single inadvertent keystroke or mouse-click can completely screw up the screen one is used to and result in hours lost trying to recover and get back to productivity. Makes me very angry. – Reinhard Neuwirth Sep 02 '17 at 14:33

score -1 · Answer 12 · answered May 06 '23 at 14:54

I had an issue after typing vba code for 3 weeks and saving etc.Then for some reason I played with the sizing of the editor and my next file open showed "none of my code" like heart attack time, tried most of internet solutions including copying baked up files and recent ones and opened on another computer and the vba was there :). OK back to original puter still no code showing and then............... I saw at bottom left of editor 2 small icon buttons, procedure view and full module view ... bingo, pretty silly, I know, but for a while it scared the bejesus out of me.

How to restore VBA Editor to its initial settings?

12 Answers12

Linked