VBA Toolbars

[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
__________________________________________________________

 

[JE McGimpsey]

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?

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

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