Before you edit a macro (macro: An action or a set of actions that you can use to automate tasks. Macros are recorded in the Visual Basic for Applications programming language.), you should be familiar with the Visual Basic Editor (Visual Basic Editor: An environment in which you write new and edit existing Visual Basic for Applications code and procedures. The Visual Basic Editor contains a complete debugging toolset for finding syntax, run-time, and logic problems in your code.). The Visual Basic Editor can be used to write and edit macros attached to Microsoft Excel workbooks.
- Set the security level to Medium or Low.
- On the Tools menu, click Options.
- Click the Security tab.
- Under Macro Security, click Macro Security.
- Click the Security Level tab, and then select the security level you want to use.
Note Permanently setting the macro security level to Medium or Low is not recommended. High macro security is the recommended macro security setting for all users, and you should return the security level to High when you are finished editing the macro.
- On the Tools menu, point to Macro, and then click Macros.
- In the Macro name box, enter the name of the macro.
- Click Edit.
- For Help with the Visual Basic Editor, on the Help menu, click Microsoft Visual Basic Help.