Command Button ActiveX Control

Question

I have some command buttons in my PowerPoint presentation. When I start the slideshow with the Presenter View hidden, when i click on the command button, it executes the command. However, when I have the slideshow in Presenter View, when i click on the command button, nothing happens. How can i get the command button to execute the action in Presenter View?

Answer 1

Glad we both helped!

Just so you know I wasn't suggesting that making the Action Button click the command button is the BEST way. If you already have command buttons then it can be the fastest but you do not actually need command buttons at all.

If you are interested take this example apart!

Answer 2

It worked!!!! I didn’t need a message box, though. Thanks so much!!! I’m going to use this forum more often for questions I have!!!

Answer 3

I just did a few quick tests, John.  A shape with an action setting (Run Macro:  my macro name) does indeed respond to clicks on either screen when viewing the show in presenter view.

There's a problem if the code displays e.g. MsgBoxes ... the MsgBox appears on the screen where you clicked.  You can probably get around that problem (if it IS a problem) by using a form instead of a MsgBox. You can control where the form appears.

Or ... here's an odd 'un ... if you create a form and show the MsgBox in its Initialize event, the message box will appear centered in the window where you clicked the button that launched the code that includes the msgbox (that lives in the presentation that Jack built ...).

Answer 4

If you already have the command buttons set up you might want to try to make the Action Button click it for you.

STEP 1

Right click the command Button > View Code

If the code starts with PRIVATE delete the word PRIVATE

Add an Action Button (does not have to be custom)

Select the action to run macro which corresponds to the command button

OK out

Answer 5

This link will give you an example of what I'm currently doing: https://www.extendoffice.com/documents/excel/4481-excel-sum-of-textbox-values.html.  How am I to do this type of thing with an Action button?  I know I would need to choose the Custom action button, but what would the VBA code look like?