How to create a progress bar in Microsoft PowerPoint

A progress bar is a graphic that is used in PowerPoint to visually represent the percentage of the completed slide show. It’s also a good indicator of the amount remaining. How to create a progress bar in Microsoft PowerPoint.

You can create a progress bar manually by adding a shape at the bottom of each slide. The problem with this approach is that you need to measure the length of each shape based on the number of slides in the presentation. Also, whenever you add or remove a slide, you must manually repeat the progress bar on each slide in the slideshow.

To keep everything consistent and to save yourself serious headaches, you can use a macro to create a progress bar. With this macro, the progress bar automatically adapts to the number of slides in the presentation.

Macros Explained: Why Microsoft Office Files can be dangerous

First, open the PowerPoint presentation for which you want to create a progress bar. Once it’s open, click the “View” tab and choose “Macros”.

The Macro window is displayed. Enter a name for your new macro in the text field under “Macro Name”. The name cannot contain any spaces. When you’re done entering it, click Create or, if you’re using a Mac, click the + icon.

Enter    Macro name and click Create

The “Microsoft Visual Basic for Applications (VBA)” window will now open. In the editor you will see this code:

                      Sub ProgressBar()

End Sub

Macro code in the editor

First, place your cursor between the two lines of code.

Cursor placement in the editor

Next, copy and paste this code:

                      On Error Resume Next
With ActivePresentation
For X = 1 To .Slides.Count
Set s = .Slides(X).Shapes.AddShape(msoShapeRectangle, _
0, .PageSetup.SlideHeight - 12, _
X * .PageSetup.SlideWidth / .Slides.Count, 12)
s.Fill.ForeColor.RGB = RGB(127, 0, 0)
s.Name = "PB"
Next X:
End With

Once pasted, your code should look like this in the editor.

Final code format in the editor

Note: There are now no line breaks between the first and last line of code.

You can now close the VBA window. Back in Microsoft PowerPoint, click Macros again on the View tab.

Macros option

Next, choose your macro name (“ProgressBar” in our example) to select it, then click Run.

Choose the ProgressBar macro

The progress bar will now appear at the bottom of each slide in your presentation.

When you delete a slide, the progress bar adjusts automatically. If you add a new slide you will need to run the macro again (View> Macro> Run). It’s a minor inconvenience compared to manual adjustment.

Related Posts