PowerPoint Macros & Automation
A macro is a recorded or written sequence of commands that PowerPoint executes automatically on demand. Instead of clicking through ten menu steps to reformat every text box on 40 slides, a macro performs the same sequence on all 40 slides in under a second. Macros eliminate repetitive manual work and reduce the risk of inconsistent formatting caused by human error.
PowerPoint macros use Visual Basic for Applications (VBA) — the same scripting language shared by Excel, Word, and Access. Knowledge of VBA in any Office application transfers directly to PowerPoint macro development.
Enabling the Developer Tab
The Developer tab — which houses all macro tools — is hidden by default. Enable it via File → Options → Customize Ribbon. In the right-hand column of available tabs, tick Developer and click OK. The Developer tab now appears in the Ribbon between View and any contextual tabs.
Recording a Macro
Click Developer → Record Macro. Give the macro a descriptive name (no spaces — use underscores: Format_Title_Slides), optionally assign a keyboard shortcut, and click OK. From this moment, every click and command you perform in PowerPoint is recorded. Perform the steps you want to automate, then click Developer → Stop Recording. The macro saves in VBA code automatically.
Running a Recorded Macro
Click Developer → Macros to see all available macros. Select your macro name and click Run. PowerPoint executes every recorded step instantly. The same result you achieved manually in two minutes runs in under one second.
The VBA Editor
Click Developer → Visual Basic (or press Alt + F11) to open the VBA Integrated Development Environment (IDE). The left panel shows all open presentations and their modules. Double-click any module to see its code. Recorded macros appear here as editable VBA subroutines — study them to understand the syntax, then modify or write new procedures from scratch.
A Simple Formatting Macro
The following subroutine loops through every slide and sets the title text colour to navy blue — demonstrating the pattern that most PowerPoint VBA macros follow: iterate through slides, access specific elements, apply a change.
Assigning Macros to Buttons
Add a macro-trigger button to the Quick Access Toolbar. Go to File → Options → Quick Access Toolbar. In the "Choose commands from" dropdown, select Macros. Your saved macros appear in the list — click one and click Add to place it on the toolbar as a button. Assign a custom icon from the Modify button dialog. Now the macro runs with a single click from any slide — no menus required.
PowerPoint blocks macros from running in files downloaded from the internet or received as email attachments, by default. This protects against malicious macro code. Your own macros stored in your local files run without restriction. Before distributing a macro-enabled presentation (.pptm), inform recipients that they must enable macros manually and explain what the macros do — this transparency builds trust and prevents security warnings from derailing the presentation.
Saving Macro-Enabled Presentations
Standard .pptx files cannot store macros — the format strips VBA code on save. Save any presentation containing macros in PowerPoint Macro-Enabled Presentation (.pptm) format via File → Save As → PowerPoint Macro-Enabled Presentation. The .pptm extension signals to recipients and to PowerPoint's security system that the file contains executable code.
Store reusable macros in a macro-enabled template (.potm) rather than in individual presentation files. Every new presentation created from that template inherits access to the macro library. This architecture separates reusable automation tools from specific presentation content — the clean professional way to manage organisational PowerPoint automation.