Docking Project Explorer Vertically

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I used to have my Project Explorer docked at the left side. Somehow it now
refuses to dock anywhere other than horizontally. I would like the Project
Explorer at the left and the modules at the right.

What am I doing wrong? It's driving me crazy!
 
ChelseaWarren said:
I used to have my Project Explorer docked at the left side. Somehow it now
refuses to dock anywhere other than horizontally. I would like the
Project
Explorer at the left and the modules at the right.

What am I doing wrong? It's driving me crazy!
Click to expand...

Hi Chelsea,

Hold down the Ctrl key then click and drag the Project Explorer window
by the title bar back to the left side. It may take a couple of tries to get
it docked there again. If you don't hit it exactly right it will either
undock or snap back to the top again.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm
 
Grab the Project Title Bar and drag it clear off the VBE window and then
drag it back to the window where you want it, watching the ghost outline to
change to vertical.
 
Thanks for the reply. I tried this at least 20 times and it will still only
dock at the top. I also tried moving it clear off the VBE window and back.
Still won't work.
 
Thanks for replying. The ghost outline turns vertical but the Project
Explorer just sits to the left without docking. I tried this with and
without the CTRL key.
 
Hi Chelsea,

If you're comfortable with editing your registry, try renaming or deleting
"Dock"

HKCU-Software-Microsoft-VBA-Common-Dock

Or for xl97, under VBA-Office

A new key should be created next time you start Excel and your VBE.

Only came across last week this because I'm also having a problem with my
VBE. Not your problem but the my main "Menu Bar" items not responding
whenever I have an addin loaded that interacts with VBE commandbars. Didn't
fix my problem though!

Regards,
Peter T
 
HKCU-Software-Microsoft-VBA-Common-Dock

typo, should be

HKCU-Software-Microsoft-VBA-6.0-Common-Dock

Peter T
 
Hi Chelsea,

If you can't fix the problem any other way, here's the sledgehammer
approach. Close Excel and open RegEdit (choose Start > Run, type RegEdit
into the Run dialog and click OK). Navigate to the following registry key:

HKEY_CURRENT_USER\Software\Microsoft\VBA\6.0\Common

On the right side look for a registry entry called "Dock" of Type
REG_BINARY. Double-click it to bring up the edit dialog, delete everything
in the Value Data box and click OK. The data for the key should now say
"(zero-length binary value)"

Start Excel again and open the VBE. All of the windows sizes and docking
positions should be reset to their defaults.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm
 
Thank you!! Thank you!!

Rob Bovey said:
Hi Chelsea,

If you can't fix the problem any other way, here's the sledgehammer
approach. Close Excel and open RegEdit (choose Start > Run, type RegEdit
into the Run dialog and click OK). Navigate to the following registry key:

HKEY_CURRENT_USER\Software\Microsoft\VBA\6.0\Common

On the right side look for a registry entry called "Dock" of Type
REG_BINARY. Double-click it to bring up the edit dialog, delete everything
in the Value Data box and click OK. The data for the key should now say
"(zero-length binary value)"

Start Excel again and open the VBE. All of the windows sizes and docking
positions should be reset to their defaults.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm
Click to expand...
 
Back
Top