Resetting VBA Windows
 

HI,

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

I hope that my question is clear.

Thanks

--
LoveCandl
-----------------------------------------------------------------------
LoveCandle's Profile: http://www.excelforum.com/member.php...fo&userid=2861
View this thread: http://www.excelforum.com/showthread.php?threadid=53325

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

Resetting VBA Windows
 

Tom,
Are you sure? Under the NT'ish operating systems HKEY_USERS\.DEFAULT is only
loaded when no one is logged on.


--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"Tom Ogilvy" wrote:
<snip
| for xl2000 (under Windows 2000)
| search under
| HKEY_USERS\.DEFAULT\Software
| for a Key named VBA,
<snip

Resetting VBA Windows
 

In Windows XP Professional, which is NT'ish, and I can see
HKEY_USERS\.DEFAULT

I didn't find the key there however. I did find it under

HKEY_CURRENT_USER\Software\Microsoft\VBA\6.0\Offic e

And I have Office 97 and Office 2000 on that machine.

So the user may have to look around a bit.

--
Regards,
Tom Ogilvy

"Dave Patrick" wrote in message
...
Tom,
Are you sure? Under the NT'ish operating systems HKEY_USERS\.DEFAULT is
only
loaded when no one is logged on.


--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"Tom Ogilvy" wrote:
<snip
| for xl2000 (under Windows 2000)
| search under
| HKEY_USERS\.DEFAULT\Software
| for a Key named VBA,
<snip

Resetting VBA Windows
 

Yes HKEY_CURRENT_USER sounds more likely.

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"Tom Ogilvy" wrote:
| In Windows XP Professional, which is NT'ish, and I can see
| HKEY_USERS\.DEFAULT
|
| I didn't find the key there however. I did find it under
|
| HKEY_CURRENT_USER\Software\Microsoft\VBA\6.0\Offic e
|
| And I have Office 97 and Office 2000 on that machine.
|
| So the user may have to look around a bit.
|
| --
| Regards,
| Tom Ogilvy