Most Valuable Professional

View Jan Karel Pieterse's profile on LinkedIn subscribe to rss feed
Subscribe in a reader

Subscribe to our mailing list

* indicates required

Audit !!!

Check out our RefTreeAnalyser
the ultimate Excel formula auditing tool.


Excel VBA Masterclass (English)
Excel VBA for Financials (Dutch)

Third party tools

Speed up your file

The best tool to optimise your Excel model!

Repair your file

Stellar Phoenix Excel Repair
Best tool to repair corrupt Excel sheets and objects
Home > English site > Articles > Docking VBE Windows
Deze pagina in het Nederlands

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:

Fig 1, Tools, Options, Docking tab for the VBE.

Suppose your window looks like this:

Fig 2, VBE window. Project explorer above Properties window.

and you want it to look like this:

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. Download the movies:

Docking the project explorer window

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:


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


Comment by: Mandora (4/9/2017 9:56:09 PM)

Even with video help could not get panes to anchor properly in Excel 10 VBA.

Exported HKEY_CURRENT_USER\SOFTWARE\Microsoft\VBA\7.0\Common from another computer and imported into wayward Excel. Problem solved!!

Note: Saved above key to Excel_VBA_Dock_Fixit and saved file for future use.


Comment by: Harikiran (6/19/2017 2:05:14 PM)


Where can i find resources which can help me start, understand and subsequently code in VBA to automate few processes in outlook and excel.

ThanQ in advance, appreciate the time!


Comment by: Jan Karel Pieterse (6/20/2017 10:05:30 AM)

Hi Harikiran,

Not easy to answer. The way people learn is personal. For example, I prefer to learn by trying to do things on real projects rather than some made-up example with no use.
I also prefer to have my information in writing and not in video so you'll never see me watching a youtube video to learn things about Excel or VBA. I'll grab a book and go from there.


Comment by: khan (7/8/2017 3:09:39 PM)

Thanks alot man my problem has been solved..Thanksss alot


Comment by: Thomas (9/12/2017 11:36:44 AM)

Now I can put my object browser on my third screen, thanks!


Comment by: Mompo (12/4/2017 1:24:58 AM)

This is very helpful!!! saves my day!


Comment by: Hilary (1/24/2018 3:40:19 PM)

Sir, Thank you

Some one opens my worksheet and goes to the editor to unhide very hidden worksheet through the view code option of the sheet. How can I lock the VB editor which has no macro, no project at all? - Exccel7-10

Would appreciate knowledge


Comment by: Jan Karel Pieterse (1/25/2018 9:34:34 AM)

Hi Hilary,

I'm afraid you can only achieve that by saving the file as an xlsm file and then password-protecting the VBA project.


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:

Please enter your name (required):

Your e-mail address (optional but if you want me to respond it helps!; will not be shown, nor be used to send you unsolicited information):

Your request or comment:

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