Here’s a question we got from a reader:
I have a need to automatically resize all images stored in a specific presentation I have to prepare for my management. As the slides are quite standard, this looks like something I could automate using a Macro. The thing is that I don’t find the macro recorder button in the PowerPoint development tab. Can you help?
Yes sure! There are many tasks that could use quite a bit of automation in PowerPoint such as:
I would like to clarify this point, as couple of readers specifically asked for this. Microsoft PowerPoint doesn’t ship a macro recorder such as the one you’ll find in Word. Therefore, you’ll need to create one manually using Visual Basic for applications (VBA), which is a relatively simple programming language used to extend Microsoft Office. That said, the process is not complicated , just follow along the instructions below.
First off, let us create a backup of your original presentation, so you can always come back to it if needed:
Open the specific presentation that you want to automate.
Save your presentation using a different file name, say MyPresentationMacro, and make sure to pick the file format .pptm (Powerpoint Macro presentation) as your file type.
Then, if you don’t see the developer button in your Ribbon, you should go ahead and enable it.
Your next step would be to insert your VBA code snippet into a Visual Basic for Applications Project Module. Follow the instructions below:
Note: Your Microsoft Office installation might have VBA Macros disabled by default. If that’s the case, from the Developer ta, hit Macro Security and select Disable all Macros except digitally signed.
If you would like to improve the usability of your VBA Macro, you can easily assign it to a button.
Couple readers asked for some Visual basic for Applications macro examples for PowerPoint. As i will need to put some significant time to document those, and as such i would like to assess the need. Kindly drop me a comment if you are looking for specific PowerPoint VBA primer.