View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Homey Homey is offline
external usenet poster
 
Posts: 143
Default 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