JKP Application Development Services.

                    Microsoft Office Application Development

Docking VBE Windows

Up • Defined Names • Corrupt Files • Create Addins • Startup Problems • Chart an Equation • Show Picture • Round2Digits • Control Events • Custom Find • FormulaWrapper • Disable Events • Workbook Open Bug • WebQuery • Register UDFs • Undo With Excel VBA • Select a range (VBA) • Transpose Table • Docking VBE Windows • Excel 2007 Tables • Excel 2007 Tables (VBA) • Update An Addin • Addin Installation • Object Lister • Excel 2007 FileFormat • Catch Paste • Listbox AutoSize
•  •

Search Zoeken

WWW
This site

Go to Ga Naar
Home
Up

Donate Donaties
Did you find something helpful on my site? Consider a donation!
Heeft u iets gevonden waar u wat aan had? Overweeg dan een donatie!

 

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?

bulletDouble click the title bar of the project explorer (it will become a floating window)
bulletDrag the center of the window back to the area where the Properties window is.
bulletKeep moving until the thickness of the window border changes to a thin line
bulletNow move downwards until you're almost at the bottom of the VBE window. The shape of the window should change.
bulletLet 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. 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:

bulletOpen the VBE and select Tools, Options
bulletSelect the Docking tab and make sure the window in question has no checkmark in that tab
bulletClose the options window and select Window, Cascade.
bulletNow open the Options dialog again and check the docking property of the window you just (hopefully) got back.
bulletDrag it to where you want it docked.

Feedback

Since you have managed to reach the end of this article, maybe you would care to write me a small message, expressing your opinion on this article?

Click here to write an email message to me.

You may also rate this article:

(Rated: 329 times, average rating: 6.3)

Comments

All comments about this page:

Comment by: Jan Karel Pieterse (12/7/2006 10:51:42 PM)

Hi Dennis,

You should know: there is no such thing as a stupid question, just silly answers and bad software!

I use Snagit for doing all my screenshots, it can also do screen movies.

Comment by: Rickard Olsson (3/5/2007 4:15:33 AM)

Agree I was suprised about the loading time of the video. But when it finally arrived I understood directly what to do. Thanks, I have tried hard for a quarter of an hour without making it. So Google and you helped me. Now I am back on track!

Comment by: jim (4/26/2007 11:59:30 AM)

It's official. You're the best. I couldn't find the properties window. Some how it had gotten undocked and it was mostly unseen to the right of my monitor. I minimized the VBE and was able to see a sliver of the properties window. Thanks for the help!!

Comment by: Wendy (11/27/2007 12:36:46 PM)

Cool. I did not use the exact method described, but did borrow the ideas of it to get my Immediate and Locals windows back into their docking places! Thanks a lot!

Add a comment too!!!

Please enter your name (required, will be shown):

Your E-Mail address (optional; will not be shown, nor be used to send you unsolicited information):

Your comments on this page (will be shown):

    Subscribe in a reader

powered by longhead.com

Use the contact page to issue questions or comments about this website.
Copyright © 2003-2007 JKP Application Development Services.