Fixing Docking Of Windows In The VBE

If you're a VBA programmer like me, you're probably picky about your window arrangements in the Visual Basic Editor. Sometimes it messes things up and it can be a challenge to get those windows where you want them.

First of all, you have to choose whether or not you want them to dock at all. Tools, options, Docking enables you to set that for each window separately:
Tools, Options, Docking tab for the VBE
Fig 1, Tools, Options, Docking tab for the VBE.

Suppose your window looks like this:
VBE window. Project explorer above Properties window
Fig 2, VBE window. Project explorer above Properties window.

and you want it to look like this:
VBE window. Project explorer below Properties window
Fig 3, VBE window. Project explorer below Properties window.

What do you do?

  • Double click the title bar of the project explorer (it will become a floating window)
  • Drag the center of the window back to the area where the Properties window is.
  • Keep moving until the thickness of the window border changes to a thin line
  • Now move downwards until you're almost at the bottom of the VBE window. The shape of the window should change.
  • Let go.

Since a picture says more than a 1000 words and a movie is worth a 1000 pictures, I've recorded my movements while doing these things. Move your mouse (or tap) on the two GIF's below to see them animate

Here is how you dock the VBA project explorer where you want it
Docking the project explorer window

Here is how you dock the VBA project explorer where you want it
Docking the watch window

Sometimes, one of the windows disappears completely. This may be caused by a change in screen resolution, but I've heard of inexplicable disappearances too. To fix that, follow these steps:

  • Open the VBE and select Tools, Options
  • Select the Docking tab and make sure the window in question has no checkmark in that tab
  • Close the options window and select Window, Cascade.
  • Now open the Options dialog again and check the docking property of the window you just (hopefully) got back.
  • Drag it to where you want it docked.

Comments

Showing last 8 comments of 133 in total (Show All Comments):

 


Comment by: Alvaro Frederico Ramos Pompeia (15-3-2023 17:31:00) deeplink to this comment

Excel project, properties, immediate windows are docked. The code of all userforms are floating and over the project and properties. Selecting maximized on a form it occupies all screen and vbe stay behind it.
(Sorry, English is not my native language).


Comment by: Jan Karel Pieterse (15-3-2023 17:43:00) deeplink to this comment

Hi Ramos,

Try what is described in this comment by Paul:
https://jkp-ads.com/articles/VBEDocking.asp?AllComments=True#31825


Comment by: dave (20-3-2023 23:44:00) deeplink to this comment

thank you so much this was spot on and saved me from going nuts!


Comment by: Jan Karel Pieterse (21-3-2023 11:31:00) deeplink to this comment

Hi Dave,

You're welcome!


Comment by: Leandra Tel (3-8-2023 23:32:00) deeplink to this comment

I think this solution would solve my problem with the VBE docking. But, I am not a programmer or IT wizard. Therefore, my question: where and how can I apply this (comment by Paul 3-6-2022 15:23):
https://jkp-ads.com/articles/VBEDocking.asp?AllComments=True#31825


Comment by: Jan Karel Pieterse (4-8-2023 11:21:00) deeplink to this comment

Hi Leandra,

First, close all Office apps.

You can access the registry editor by clicking the Windows find box and typing regedit and pressing Enter. Then you can paste this

Computer\HKEY_CURRENT_USER\SOFTWARE\Microsoft\VBA\7.1\Common

into its address bar. Hit Enter to get you there. On the right-hand side, find an entry called Dock. Right-click it and choose Delete. This can be done safely as the VBE recreates that key when it opens.


Comment by: Leandra Tel (8-8-2023 23:41:00) deeplink to this comment

Hi Jan,

Thanks for the instruction to enter the registry editor. I was able to find and delete that entry. Unfortunately, the result wasn't what I hoped for. The windows in VBE don't dock nicely but are all separate, and when I add a new window, I must rearrange them manually. It was worth a try to solve it. I will have to get used to it, I guess.
Best, Leandra


Comment by: Jan Karel Pieterse (9-8-2023 09:24:00) deeplink to this comment

Hi Leandra,

What settings are checked in the VBE's Tools, Options, Dock tab? Mine has all but the last one checked.


Have a question, comment or suggestion? Then please use this form.

If your question is not directly related to this web page, but rather a more general "How do I do this" Excel question, then I advise you to ask your question here: www.eileenslounge.com.




To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].