Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In the Excel 2007 VBA Programmer's Reference (by John Green, Stephen Bullen,
Rob Bovey and Michael Alexander), they state: ----- "As well as being able to retrieve the state information, you can also click any built-in control using the new ComandBars.ExecuteMso method. This is extremely useful for triggering those actions that dont have an object model equivalent€”such as putting the user in drawing mode to draw a text box on a sheet:" Application.CommandBars.ExecuteMso €śTextBoxInsertExcel€ť ----- While the above works, when I try to use this method with a gallery control, like: Application.CommandBars.ExecuteMso "CellStylesGallery" I expect either the book is wrong (i.e., the method does not apply to "any built-in control"), or there is some syntax I have wrong in applying this. Can anyone advise how to make this work? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Making touchpad's Horizontal Scroll region work in Excel/Word 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 - Personnal CommandBars | Excel Programming | |||
GetObject method not work after Call Shell Method | Excel Programming | |||
Why QUIT method doesn't work after COPY method? | Excel Programming | |||
Making VB PasteSpecial method to work the same as Excels Application | Excel Programming |