VBA-Table formatting

E

Edward

Hi every one,
In PP2003 we can use the following code to change all cell formatting in a
table at once. first select the table and then run the following code
ActiveWindow.Selection.TextRange.ParagraphFormat.Alignment = ppAlignRight
in 2007 this code generates an error ( it doesn't recognize any selection)
I know I can loop through each cell and change the formatting , but is there
any easer way to change the formatting of all cells in a table at once in
PP2007?
 
S

Shyam Pillai

Edward,
I don't recall being able to do the same even in PPT 2003.

In 2007, you either do it cell by cell or if you going to select the shape
then you can also use:

Application.CommandBars.ExecuteMso "AlignRight"

Regards,
Shyam Pillai

Handout Wizard: http://skp.mvps.org/how
 
E

Edward

Using commandbar controls is 2 times faster for a a 6x8 table.
where can I find all the names for commandbar controls ?
Application.CommandBars.ExecuteMso ?
because intelisense doesn't give us any options , can I find those constants
in PP help?
--
Best regards,
Edward


Shyam Pillai said:
Edward,
I don't recall being able to do the same even in PPT 2003.

In 2007, you either do it cell by cell or if you going to select the shape
then you can also use:

Application.CommandBars.ExecuteMso "AlignRight"

Regards,
Shyam Pillai

Handout Wizard: http://skp.mvps.org/how
 
S

Shyam Pillai

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

Top