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

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


Randal W. Hozeski wrote in message
news:0qGFb.427380$Dw6.1313739@attbi_s02...
I screwed up the layout of my Editor. It had the Project Explorer visable
along with the Properties on the lefthand side of the screen and on the
right
it showed the UserForm/Code/ etc.

I have to keep on clicking the Project Explorer button now and hitting the
F4 key to see the properties pane.

How can I set this back to the default layout? -Randy-

PS: A side request: How come my mousewheel does not work in the
Editor's code area? If this is not an option... I would consider a
different
Editor... using Excel 2000 9.0.6926 SP-3

.