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

File crashes Excel!!

Save my workbook!
The best tool for salvaging problematic workbooks.

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 108 in total (Show All Comments):

 


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.

 


Comment by: Eric Hofer (6/1/2018 1:43:09 PM)

Regarding the immediate window disappearing. Could it be that you've changed your screen configuration? Perhaps you had 2 monitors and now you're on just 1?

If so, and you're sure that the Immediate Window is turning on, but just not visible, it could be out of the viewable area. But it's likely still "Active." Given that, use the standard Windows tools and move it via the keyboard.

1) Hold down the ALT key and press SPACEBAR.
2) Press M (for Move).
3) Now use the arrow keys to move it until it appears.
4) When it's in the right position, press ENTER.

 


Comment by: Jan Karel Pieterse (6/1/2018 4:55:12 PM)

HI E.

Often using the cursor keys to get the window into view is hard because you don't know which direction to go.

Solution: hit any of the arrow keys just once and then grab the mouse and move it. The window will come with the pointer, which never leaves the edges of your screen

 


Comment by: CassieGriffin (11/1/2018 8:50:18 PM)

window arrangements are a way to keep in manage window and docking is stop its work and we face several trouble but after reading your post, I am able to solve this issue. Check it https://babasupport.org/windows/windows-error-0x8024200b for window error

 


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, will only be used to inform you when your comment is published or to respond to your question directly):

Your request or comment (max 2000 characters):

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

I give permission to process this data and display my name and my comment on this website accoring to our Privacy Policy.