VB for Custmize / Options

[Guest]

I'd like to control some of the options for the Toolbars using vb.
Specifically want to turn on the check for "Show Standard and Formatting
toolbars on two rows". Any Help is appreciated.

Ken

 

[Jim Cone]

Ken,

I can't find a built-in property or method, but the following works...
'-------------------------------
Sub AnotherTest()
With Application.CommandBars("formatting")
.RowIndex = Application.CommandBars("standard").RowIndex + 1
.Left = Application.CommandBars("standard").Left
End With
End Sub
'-------------------------------

Jim Cone
San Francisco, USA

 

[Guest]

Jim,
Thank you so much... I totally wasn't thinking about the obvious. This
works as it should.

Still looking for Properties or Methods to handle the Customize / Options
but my initial objective has been met.

Thanks Tons,
Ken