VBA-Table formatting

  • Thread starter Thread starter Edward
  • Start date Start date
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?
 
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
 
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
Click to expand...
 
Back
Top