Keep a PowerPoint VBA Calculator Interactive During a Slide Show
Question details
The user needs a calculator associated with a PowerPoint slide that remains usable during a slide show without blocking presentation controls.

- 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.
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.
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.
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.
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.
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.
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.
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.

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.

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.




