Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 31
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,510
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,953
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Visual Basic Editor Ron Rueter Excel Discussion (Misc queries) 3 October 28th 08 02:48 PM
please help : Excel visual basic editor AMIT Excel Programming 2 March 16th 07 08:01 PM
Visual basic editor Answerfactory Excel Discussion (Misc queries) 3 October 9th 06 09:13 PM
Can I run Visual Basic procedure using Excel Visual Basic editor? john.jacobs71[_2_] Excel Programming 3 December 26th 05 02:22 PM
VBE(Visual Basic Editor) Keep focus in VBE phil[_4_] Excel Programming 4 August 11th 05 12:25 AM


All times are GMT +1. The time now is 06:45 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"