VBA & Macro Problems

Keep a PowerPoint VBA Calculator Interactive During a Slide Show

John WilsonJohn Wilson Nov 14, 2026 868 views

Question details

The user needs a calculator associated with a PowerPoint slide that remains usable during a slide show without blocking presentation controls.

Keep a PowerPoint VBA Calculator Interactive During a Slide Show
Product
Microsoft PowerPoint
Device & OS
not provided
Scenario
A presenter wants to open and use a VBA calculator while presenting a specific slide.
Observed behavior
PowerPoint cannot be used while the current calculator is open; the user must close it to continue.
Before you start

Confirm that the calculator is a VBA UserForm and that it needs to work in Slide Show mode. Save the presentation as a PowerPoint Macro-Enabled Presentation (.pptm) and check whether the target computer permits trusted macros.

Solution 1Recommended

Open the VBA calculator as a modeless form

Use a modeless UserForm when the existing calculator blocks PowerPoint until it is closed.

A modeless form can stay open while you interact with PowerPoint. It appears over the presentation rather than becoming a permanent object embedded in the slide.

If the calculator uses a continuous loop or lengthy procedure, change that code to respond to button events and return control to PowerPoint; making the form modeless alone will not fix blocking code.

1
Check the calculator form

Open the presentation in PowerPoint and press Alt+F11 to open the VBA editor. In the Project pane, identify the calculator UserForm and note its name.

2
Add a launch macro

In the VBA editor, select Insert > Module and add a public macro such as: Public Sub ShowCalculator() CalculatorForm.Show vbModeless End Sub Replace CalculatorForm with the actual UserForm name.

3
Link the macro to the slide

Return to the target slide, insert or select a shape, and choose Insert > Action. On the Mouse Click tab, select Run macro, choose ShowCalculator, and click OK.

4
Save and test the presentation

Choose File > Save As and select PowerPoint Macro-Enabled Presentation (.pptm). Start Slide Show, click the shape, and verify that the calculator works and you can still navigate the presentation.

5
Test on the presentation computer

Open the .pptm file on the target computer, enable macros only if the file is trusted and policy permits it, and repeat the slide-show test. If the calculator uses ActiveX controls, check that those controls are also supported and allowed.

Open the VBA calculator as a modeless form
For a calculator drawn on the slide: A UserForm is a separate window. To make the calculator appear as part of the slide itself, build its display and buttons from slide shapes and assign VBA macros to the buttons; this requires adapting the calculator code.
Free Microsoft Office alternative

Create and edit presentations with WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for editing and presenting Office files. Open existing presentations to make the transition easier, but test advanced features separately: WPS does not fix PowerPoint VBA or ActiveX behavior.

Create and present slides in a familiar interfaceCompatible with Microsoft PowerPoint formats, including PPT and PPTXOpen existing presentation files for easier migrationFree and lightweight for everyday Office work
microsoft office alternative - wps office

Frequently Asked Questions

Why does PowerPoint stop responding while my calculator is open?

A modal UserForm requires you to close it before returning to PowerPoint. Launching the form with UserFormName.Show vbModeless can allow interaction with the presentation, provided the calculator code is not blocking execution.

Can I open the calculator from a specific slide?

Yes. Select a shape on that slide, choose Insert > Action, and assign a public launch macro under Run macro. Click the shape during Slide Show to open the form.

Will a modeless UserForm be embedded in the slide?

No. It is a separate window displayed over PowerPoint. For a calculator that looks like part of the slide, use slide shapes as buttons and a display, then connect them to VBA macros.

Why does the calculator work on my computer but not on the presentation computer?

The target computer may block macros or ActiveX controls, or it may not support the controls used by the calculator. Test the .pptm file and its controls on that computer before presenting, and enable macros only for a trusted file when permitted.

Which file format preserves the calculator's VBA code?

Use File > Save As and select PowerPoint Macro-Enabled Presentation (.pptm). A standard .pptx file does not preserve VBA macros.