View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Resetting VBA Windows

Close Excel

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 named 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.


-----------------------------------


If Version 2002 or 2003 look for


HKEY_CURRENT_USER\Software\Microsoft\VBA\6.0\Commo n\Dock


--
Regards,
Tom Ogilvy
"LoveCandle" wrote
in message ...

HI,

My VBA windows are really in a miss How can reset them In other
words how can I take VBA windows back to the default arrangement (VBA
Project window on the top left - properties window on the bottom left
and the code window on the right of them).

I hope that my question is clear.

Thanks,


--
LoveCandle
------------------------------------------------------------------------
LoveCandle's Profile:

http://www.excelforum.com/member.php...o&userid=28612
View this thread: http://www.excelforum.com/showthread...hreadid=533251