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

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

From: Tom Ogilvy )
Subject: 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.

--
Regards,
Tom Ogilvy
"Nathan" wrote in message
...
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

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!



"Tom Ogilvy" wrote in message
...
to get to the default (from a previous post):

From: Tom Ogilvy )
Subject: 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.

--
Regards,
Tom Ogilvy
"Nathan" wrote in message
...
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