Table Style dialog

  • Thread starter Thread starter sebastien
  • Start date Start date
S

sebastien

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
 
This seem work ok

CommandBars.ExecuteMso "TableStyleNew"

H

| 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
 
Back
Top