Table Style dialog

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
 
H

Homey

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changes in How Code Acts After Upgrade of Excel 2
Dialog Box Buttons 1
Table moves when applying styles 3
Custom Table Styles 2
Extracting specific items from large IE table 6
change default table style 1
Dialog Box with Multiple Items 2
Can you create custom Table Styles? 4

Top