Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Help and How-to
Search
Search
 
Check for updates: (c) Microsoft
Microsoft Update
 
 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this linkEmail this link Printer-Friendly VersionPrinter-Friendly Version Bookmark and ShareShare
Troubleshoot macros
 

Because macros can contain viruses, be careful about running them. Take the following precautions: run up-to-date antivirus software on your computer; set your macro security level to high; clear the Trust all installed add-ins and templates check box; use digital signatures; maintain a list of trusted publishers.

ShowWhen I click Refresh, a message tells me that my macro changes will be lost.

This message appears when you have made changes to a macro (macro: An action or a set of actions you can use to automate tasks. Macros are recorded in the Visual Basic for Applications programming language.) in Microsoft Visual Basic Editor (Microsoft Visual Basic Editor: An environment in which you can edit macros that you've recorded and write new macros and Visual Basic for Applications programs.) and have also changed the copy of your presentation in Microsoft Script Editor (Microsoft Script Editor: Used to add text, edit HTML tags, and edit any Microsoft Visual Basic Scripting Edition (VBScript) code in a data access page. You can also view your page in the Script Editor as it would appear in a Web browser.).

To save the changes to your macro, do the following:

  1. Click No when the message appears.
  2. Switch to the Visual Basic Editor window.
  3. On the File menu, click Export File to export any modules (module: A collection of declarations, statements, and procedures stored together as one named unit. There are two types of modules: standard modules and class modules.) you have changed.
  4. In your presentation in Script Editor, click Refresh Button image on the Refresh toolbar (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, click Customize on the Tools menu, and then click the Toolbars tab.), and then click Yes.
  5. In Microsoft PowerPoint, import the modules to restore the changes to your macro.

ShowWhile recording a macro, I recorded an action I didn't want.

To undo an unwanted action in a macro (macro: An action or a set of actions you can use to automate tasks. Macros are recorded in the Visual Basic for Applications programming language.), you can open the macro in Microsoft Visual Basic Editor (Microsoft Visual Basic Editor: An environment in which you can edit macros that you've recorded and write new macros and Visual Basic for Applications programs.) (Tools menu, Macro command, Visual Basic Editor submenu) and remove any unwanted steps.

ShowA macro I recorded sometimes produces an error message.

A macro (macro: An action or a set of actions you can use to automate tasks. Macros are recorded in the Visual Basic for Applications programming language.) you record may not run properly in every situation. If the macro cannot run, Microsoft PowerPoint displays an error message. Some macros depend on certain options or settings in PowerPoint. For example, a macro that inserts a drawing object won't run properly if you are in slide sorter view. If a macro you've recorded produces an error message, note the error number. You can then search for "error messages" in Microsoft Visual Basic Help and find information about the message you received.

advertisement