Docking windows in the IDE

[Nathan]

Hi

I have accidently cliked or dragged something in the vb
ide in Excel. Now my windows are all floating and cant
get them to go back to the way they were. I used to have
Project explorer locked on the left hand side and the
remainder of the screen split between my immediate window
and the code window.

Can anyone help on how to get these back, i have tried
messing around with the dockable option, but still cant
get it to work.

nath

 

[Tom Ogilvy]

to get to the default (from a previous post):

From: Tom Ogilvy ([email protected])
Subject: Re: VBA Editor SetUp


View this article only
Newsgroups: microsoft.public.excel.programming
Date: 2003-12-23 16:18:09 PST

start regedit

find the key

HKEY_USERS\.DEFAULT\Software\Microsoft\VBA\Office
That is for excel 97 on Windows 98 SE

for xl2000 (under Windows 2000)
search under
HKEY_USERS\.DEFAULT\Software
for a Key name VBA,
then under that 6.0\Common

Find the Key named

Dock

and delete it.

Then open excel and the VBE should be back to the default.

I assume the key will be similar in other version/OS combinations.

 

[wysiwyg]

This has been driving me nuts forever! Anyone know where I find it the key
in XP? The only VB/VBA folder I can find is in HKEY_CURRENT_USER > Software

VB and VBA Program Settings, and I do not have a key name Dock there.

Thanks!

 

[Dave Peterson]

For me (win98, xl2002), it was:

hkey_current_user\software\microsoft\VBA\6.0\common\
with a key of DOCK.

If you still have trouble, open Regedit and Edit|Find, and look for dock.

(Be a little careful not to delete the wrong one!)

(You can backup the registry first if you want:
Registry|export registry file)