Visual Basic Editor Layout

N

nir020

Hello

Can someone help with my visual basic editor layout.

Previously when I opened my visual basic editor the project explorer, the
properties window and whatever module was open be arranged in an organised
fashion. When I maximised the module window it would only occupy the left
hand side of the screen and you could still see the project explorer and
properties window which proved very helpful. Now when I maximise the the
module window it occupies the whole screen which is very unhelpful,

Is there any way of resetting this property?
 
T

Tom Ogilvy

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.

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

If Version 2002 or 2003 look for


HKEY_CURRENT_USER\Software\Microsoft\VBA\6.0\Common\Dock
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top