Home Newsletter

Deze pagina in het NederlandsHome > Article index > Docking VBE Windows

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?

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:


Comments

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

 


Comment by: 14 years late (6-12-2020 16:51:00) deeplink to this comment

Your video deserve a Nobel prize. Thanks!


Comment by: James (3-3-2022 16:18:00) deeplink to this comment

Thank you very much for sharing.
Though it wasn't a big deal, it was very annoying to me.
I could never figure this out myself.
Thank you!


Comment by: Jan Karel Pieterse (3-3-2022 16:31:00) deeplink to this comment

Hi Jim,

Glad it proved helpful!


Comment by: Nate (25-3-2022 07:19:00) deeplink to this comment

Is there a way to put them side by side instead of stacked?


Comment by: Jan Karel Pieterse (25-3-2022 11:57:00) deeplink to this comment

Hi Nate,

Yes, but how precisely depends on whether you want them side-by side in the vertical pane or at the bottom or top in a horizontal fashion. Pay attention to the shape of the "window" you see while you're dragging it, it tries to tell you how it will drop.


Comment by: PAUL H HOSSLER (3-6-2022 15:13:00) deeplink to this comment

In the editor, I used to have the Watch and/or Immediate windows docked and shown as 'Tiles' so that they were at the bottom of the screen and not floating over the module window.

Now when I open them with docked = checked, they still float.

How can I get them to tile at the bottom like they used to?

Thanks


Comment by: PAUL H HOSSLER (3-6-2022 15:23:00) deeplink to this comment

Update if you're interested

Deleted this

HKEY_CURRENT_USER\SOFTWARE\Microsoft\VBA\7.1\Common\Dock

from the registry, opened an Office app, and the watch and immediate windows are now tiles and back where they belong (or at least where I like them)


Comment by: Jan Karel Pieterse (3-6-2022 19:50:00) deeplink to this comment

Hi Paul,

I was going to suggest something like that. Glad you got it sorted


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].