VBA Toolbars

F

Francis Hookham

Recently Bernard Ray helped with the code below where all three VBA toolbars
are on view when the VBA editor is opened

Can that code be extended so the Properties window does not open?

Even better, can the Projects window be moved to a position to the right of
the screen? Of course I realise I should have to experiment with x-y dims

Francis Hookham
__________________________________________________________
 
J

JE McGimpsey

Francis Hookham said:
Recently Bernard Ray helped with the code below where all three VBA toolbars
are on view when the VBA editor is opened

Can that code be extended so the Properties window does not open?
Click to expand...

Change

.Windows("Properties").Visible = True

to

.Windows("Properties").Close

which is equivalent to

.Windows("Properties").Visible = False
Even better, can the Projects window be moved to a position to the right of
the screen? Of course I realise I should have to experiment with x-y dims
Click to expand...

IIRC, the .Top and .Left properties of the Projects and Properties
windows cannot be set programmatically.
 
Top