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.

Trainings

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

Third party tools

Speed up your file

FastExcel
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:


Comments

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

 


Comment by: Mark W. Stump (1/13/2016 2:44:44 PM)

Thank you Jan Karel :-)

I have come to this page several times when I forget how to unscrew what I accidently drug around. Very handy tips indeed!

Thanks again,

Mark

 


Comment by: Rodolfo Castro (2/26/2016 3:35:46 AM)

When I click on the VB editor I get a page with my macros, no toolbar. If I right click on that page I get a few commands, and very difficult to use. I am using Excel10 and I recently "upgraded" to Windows 10, from Windows7, where I never had any problems like missing VBA toolbars. I am at a total loss. What can I do?

 


Comment by: Jan Karel Pieterse (2/26/2016 2:31:48 PM)

Hi Rodolfo,

If you have access to your registry, you could try this:

- Close ALL VBA Editor windows. Better yet, close all Office applications.
- Open the registry editor (regedit.exe)
- Navigate to this key:

HKEY_CURRENT_USER\Software\Microsoft\VBA\7.0\Common

- Right-click it to export it (select your desktop to make it easy to find it).
- Find an item on the right called "UI" and delete it.
- Open Excel and the VBA editor
- If that fixed things you're done of course. If not, you may consider double-clicking the registry backup file to restore the key.

 


Comment by: Helen Rolls (8/26/2016 1:11:24 AM)

Thanks. Not being able to dock the Immediate Pane after accidentally undocking it has been driving me nuts!

 


Comment by: Chris (11/17/2016 1:12:52 AM)

Ten years on and your advice is still helping out! Many thanks JK!

 


Comment by: saeid (12/4/2016 11:29:25 AM)

THANK YOU For Help!

 


Comment by: Itunu (2/9/2017 5:46:52 AM)

Thanks for this actually. Sometimes you never know how helpful this is.

Great Job.

 


Comment by: Sajith Sudhi (3/13/2017 6:39:42 PM)

you are a life saver. That video really helped me. Thank you so much

Super Job.

 


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.

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