I undocked my gosh-darn properties window and now I can’t get it back to the lower left corner. I run into this problem a couple of times per year, and I can never remember how I solved it. I found a thread at Mr. Excel’s forums (for which I cannot provide a proper link) that had a few answers.
If you line up the top and left of the properties window with the top and left of the project window, the properties window will dock above the project window. You can then repeat the process to get the project window back on top. All of this assumes you use the default layout of project window on the top left, properties window on the bottom left, code pane on the top right, and immediate window on the bottom right.
That works pretty well, but it doesn’t work for the immediate window. I can dock that on top of the Code Pane, but I can’t then drag the Code Pane back on top of the Immediate Window. Another option is to delete the registry key that holds this information so that the VBE has to recreate it. That’s what I did and it worked like a peach.
Of course you should never work with the registry unless you are a highly skilled electrical engineer, make frequent backups, or have a nerdy relative that can fix what you screw up.
If that applies to you, you can download FixVBEDocking.zip which rewrites part of your registry to the default values (for VBA 6.0 that comes with Excel 2003). I make no warranty that this will work with your installation. The contents of the .reg file are:
If you know of a better way, please leave a comment.