Table Style dialog
 

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

Table Style dialog
 

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

Table Style dialog
 

Perfect. Thank you.

Sebastienm