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

Style Gallery View 3
Display New Table Style dialog 0
VBA - (re-) Set a Table Style 2
Word 2016 - Difficulties Learning Style Creation/Application 0
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Setting column width in a table with a macro is not working 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
My custom number list doesn't seem to save? 1

Top