Toobar Customisation

  • Thread starter Thread starter Andrew Glennie
  • Start date Start date
A

Andrew Glennie

Hi All,

I am working on a highly customised Citrix environment in which my Excel
toolbar setting won't stick. I wish to have the Standard and Formatting
toolbars in 2 rows, and the Drawing toolbar running as well. As I am somewhat
tired of having to do this manually every time, I am hoping there is code to
at least set the Standard and Formatting toolbars in 2 rows - the Drawing
toolbar I can cope with.

Thanks in advance.

Regards

Andrew
 
Open a blank XL file, setup your toolbars, and close. Changes should be saved
to your Personal file.

If that doesnt' work, you can at least go to Tools, Customize-Options, and
select the box to display Standard and Format toolbars on seperate lines.
 
Thanks Luke,

Unfortunately, each night and every tmie I login from scratch, the settings
are lost. From other topics, I suspect the file storing these settings is
being lost or corrupted.

Andrew
 
Answered my own question with the following code:

With Application.CommandBars("Standard")
.Position = msoBarTop
.RowIndex = 3
.Left = 0
End With
With Application.CommandBars("Formatting")
.Position = msoBarTop
.RowIndex = 4
.Left = 0
End With
Application.CommandBars("Drawing").Visible = True

Thanks

Andrew
 
Back
Top