VBA Editor SetUp

  • Thread starter Thread starter Randal W. Hozeski
  • Start date Start date
R

Randal W. Hozeski

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

..
 
For the scrolling you can probably solve it with the right mouse driver. Do
a message search on this newsgroup for

"Mouse Wheel Trouble in Excel VBA"

Lots of posts on that one. In one of these, Harald Staff says (8/12/03 11:52
AM):

"MS mice and a few others scroll those windows, Logitech mice and a few
others doesn't.

I use an optical Logitech myself, but I installed MS Intellipoint drivers
and software from:
http://makeashorterlink.com/?W191210C2

It works like a charm, scrolling code, acceleration and everything. Worth a
try."

Can't help with the panes problem as I can't reproduce it. Maybe try an
Excel re-install?

HTH,
Shockley
 
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.
 
Back
Top