Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Visual Basic Editor Layout
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Visual Basic Editor Layout
Select menu item View-Project Explorer
Regards, OssieMac "nir020" wrote: 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Visual Basic Editor Layout
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\Commo n\Dock -- Regards, Tom Ogilvy "nir020" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Visual Basic Editor | Excel Discussion (Misc queries) | |||
please help : Excel visual basic editor | Excel Programming | |||
Visual basic editor | Excel Discussion (Misc queries) | |||
Can I run Visual Basic procedure using Excel Visual Basic editor? | Excel Programming | |||
VBE(Visual Basic Editor) Keep focus in VBE | Excel Programming |