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" wrote in message
...
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!

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

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.

"Rob Bovey" wrote:

"ChelseaWarren" wrote in message
...
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!

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

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

"ChelseaWarren" wrote in message
...
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.

"Rob Bovey" wrote:

"ChelseaWarren" wrote in
message
...
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!

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

HKCU-Software-Microsoft-VBA-Common-Dock

typo, should be

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

Peter T

Thank you!! That was it.

"Peter T" wrote:

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\Commo n

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

"ChelseaWarren" wrote in message
...
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.

"Rob Bovey" wrote:

"ChelseaWarren" wrote in
message
...
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!

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

Thank you!! Thank you!!

"Rob Bovey" wrote:

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\Commo n

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

"ChelseaWarren" wrote in message
...
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.

"Rob Bovey" wrote:

"ChelseaWarren" wrote in
message
...
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!

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.
"ChelseaWarren" wrote in message
...
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!

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.

"Mike Fogleman" wrote:

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.
"ChelseaWarren" wrote in message
...
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!