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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Andrew Glennie" wrote:

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

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

"Luke M" wrote:

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Andrew Glennie" wrote:

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

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

"Andrew Glennie" wrote:

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