Procedure – Name of the Macro (Sub Procedure) Example 1 – Excel VBA Assign hotkey to MacroĪssume that you have already written or recorded a Macro called Macro1. Hotkey must not be empty in order for the hotkey to work. All Rights Reserved.The above table and the below table are used to make a combination of “key” parameter. For more information, please refer to the ? Section. It is not possible to assign shortcut keys to your recorded macros although there is an add-in that can be used to make this possible. This is not technically right and is discussed in the advanced sections. You can also use the key combination (Ctrl + Break) to interrupt a macro. This will display a dialog box allowing you to either Continue, End or Debug your macro. You can interrupt a running macro by pressing the ESC key. These should be stored in an add-in and not a specific presentation.Īny macros that are available from any additional PowerPoint add-ins are not displayed in the (Tools > Macro > Macros) dialog box.
This is slightly more complicated and there are specific pages giving step by step instructions on how to do this following on from this page.Īny macros that are added to existing toolbars and menus will be accessible from any presentation. You could run your macro by using an additional button on either a toolbar or a drop-down menu. There are two tabs and there are several actions which you can change and customise.įor more information on running macros using AutoShapes and other objects, please refer to the ? Section.Īssigning to an existing toolbar or drop-down menu (Slide Show > Action Settings) dialog box Select the graphic or AutoShape with the Right mouse button and select "Action Settings". This can be done by selecting (View > Toolbars > Drawing). To insert an AutoShape you have to display the Drawing toolbar. It is possible to run your macros in two ways:ġ) When the shape is clicked (with the left mouse button)Ģ) When the mouse if moved over the shape.Īdd the shape you would like to use to the corresponding slide. You could run your macro by using a graphic or AutoShape. ' Macro recorded #date# by Russell Proctor
Public is the default for all recorded macros. You can prevent a macro from appearing in this list by declaring it as "Private" as opposed to Public. The macros that appear in this dialog box will be any that have been recorded as well as any that have been written.Īny macros that have the same name as those in the active presentation are prefixed by the name of the presentation. It is possible to change the "Macro in" drop-down box to display the macros from all the open presentations. The default is to display all the macros that are currently available in the active presentation. Select the name of your macro from the list and press the "Run" button.Īlternatively you can use the shortcut key (Alt + F8) to display the Macro dialog box. You could run your macro from the Macro dialog box.
Running a macro is very easy and there are several ways you can do this.Ģ) Using a graphic or AutoShape with the Action Settings dialog box.ģ) Using a Button assigned to an existing toolbar or drop-down menu. You can run macros that are either in the current presentation or in any other open presentation.