Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
tools options view window options | Excel Discussion (Misc queries) | |||
IF with 3 options | Excel Worksheet Functions | |||
how do I add more toolbar options to my right click options | Excel Discussion (Misc queries) | |||
Options | Excel Discussion (Misc queries) | |||
FTP options | Excel Discussion (Misc queries) |