Re: VBA-Table formatting

Tech-Archive recommends: Fix windows errors by optimizing your registry


2007 Office System Document: Lists of Control IDs
http://www.microsoft.com/downloads/details.aspx?familyid=4329D9E9-4D11-46A5-898D-23E4F331E9AE&displaylang=en


Regards,
Shyam Pillai

Image Importer Wizard: http://skp.mvps.org/iiw.htm

"Edward" <Edward@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:64239A09-8823-4C1D-A9B0-4AA84C95BECE@xxxxxxxxxxxxxxxx
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" wrote:

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




"Edward" <Edward@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6EA7244A-3B1A-44AD-8D0A-24AB0801278E@xxxxxxxxxxxxxxxx
> 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?
> -- > Best regards,
> Edward


.

Relevant Pages

  • OT Cell phones (was Re: My new toy!)
    ... But that's probably because most of my cell calls are from work. ... Edward H. Dreschnack ... : Best Regards ...
    (rec.crafts.textiles.quilting)
  • Re: Is it possible?
    ... I'm missing something, but I don't see what it could be? ... Regards, ... >>> the status bar. ... >>> Click in a cell containing the formula. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: excel page numbers
    ... "Tom Ogilvy" schrieb im Newsbeitrag ... Also it won't work for the OP's problem if he uses rows to repeat ... >> Regards Ron de Bruin ... >>>> want in a cell in that range. ...
    (microsoft.public.excel.programming)
  • Re: excel page numbers
    ... "Tom Ogilvy" wrote in message ... Also it won't work for the OP's problem if he uses rows to repeat> at ... >> Regards Ron de Bruin ... >>>> want in a cell in that range. ...
    (microsoft.public.excel.programming)
  • Re: how can hide and show columns using macro?
    ... > Hi Hoshyar ... > the cell. ... >> Many thanks for you answer Tom. ... >>> Regards, ...
    (microsoft.public.excel.programming)