Visual Basic Editor Layout

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nir020 - 28 Sep 2007 11:09 GMT

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?

Reply to this Message

OssieMac - 28 Sep 2007 11:52 GMT

Select menu item View->Project Explorer

Regards,

OssieMac

> Hello
>
[quoted text clipped - 8 lines]
>
> Is there any way of resetting this property?

Reply to this Message

Tom Ogilvy - 28 Sep 2007 13:18 GMT

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

Signature

Regards,
Tom Ogilvy

> Hello
>
[quoted text clipped - 8 lines]
>
> Is there any way of resetting this property?

Reply to this Message