PowerPoint Macro to distribute shapes vertically
Posted on 2012-09-14
I know essentially nothing about macros but really need one here.
I am working on several hundred PowerPoint presentations, each containing several hundred slides. On each slide is one text box and one table. In short: the table overlaps the text box and I want to distribute them vertically on the slide.
The problem is that the PowerPoints are created by exporting data from an online application directly into PowerPoint. The export aligns everything horizontally (centered) but the text boxes and tables overlap. There is no way to change the features or settings of the export.
As my only other option is to manually drag each table on each slide, or select all and distribute vertically, I would MUCH rather have a macro to do this.
I have explored quite a lot of samples of VBA code and can even get one that works, provided I have manually selected all of the shapes on the slide, which sort of defeats the purpose.
I know I need something like the following sequence (this is just what I want to happen, not an attempt at code):
For each slide in the presentation
Select all shapes (or select shape range?)
That's it! That's all I need! But I cannot make it happen. To help matters, I'm using Office 2011 on a Mac and there is no "record macro" feature. It simply isn't included.
Help? Anyone? Please?