VB for Custmize / Options
 

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

VB for Custmize / Options
 

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


"vb_Sagacious" wrote in message
...
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

VB for Custmize / Options
 

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

"Jim Cone" wrote:

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


"vb_Sagacious" wrote in message
...
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