Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
In XL 2007, I have a Table. I am trying to programmaticaly display the 'New Table Quick Style' dialog. Manually it is accessible by - selecting a cell in the Table - in the Table Tools Design context ribbon, in the Table Style group, at the bottom, there is a 'New Table Style' button - click it to display the dialog. I couldn't find it in he Application.Dialogs() list. Any idea? Thank you, Sebastien |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
This seem work ok
CommandBars.ExecuteMso "TableStyleNew" H "sebastien" wrote in message ... | Hi, | In XL 2007, I have a Table. I am trying to programmaticaly display the 'New | Table Quick Style' dialog. | Manually it is accessible by | - selecting a cell in the Table | - in the Table Tools Design context ribbon, in the Table Style group, at | the bottom, there is a 'New Table Style' button | - click it to display the dialog. | | I couldn't find it in he Application.Dialogs() list. | Any idea? | | Thank you, | Sebastien |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Perfect. Thank you.
Sebastienm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
change default table style | Excel Worksheet Functions | |||
cell style dialog boxes greyed out | Excel Discussion (Misc queries) | |||
Display New Table Style dialog | Excel Programming | |||
table quick style | Excel Discussion (Misc queries) | |||
Excel 2007 - table style default | Excel Worksheet Functions |