On the Stop Recording toolbar, click Relative Reference
Notes: The first character of the macro name must be a letter.
In the Macro name box, enter a name for the macro.On the Tools menu, point to Macro, and then click Record New Macro.Click the Security Level tab, and then select the security level you want to use, either Medium or Low.Under Macro Security, click Macro Security.Set the security leve to Medium or Low.Before you create a macro - set the security level Whenever you open a workbook that contains macros, you can verify their source before you enable them. If you share macros with others, you can certify them with a digital signature so that other users can verify that they are from a trustworthy source. Macro securityĮxcel provides safeguards that help protect against viruses that can be transmitted by macros. To make a macro run whenever you click a particular button or press a particular key combination, you can assign the macro to a toolbar button, a keyboard shortcut (shortcut key: A function key or key combination, such as F5 or CTRL+A, that you use to carry out a menu command. You can run a macro by choosing it from a list in the Macro dialog box. If you make a mistake when you record the macro, corrections you make are also recorded.
You then run the macro to repeat, or "play back," the commands.
#HOW TO WRITE A MACRO IN EXCEL 2003 SERIES#
When you record a macro, Excel stores information about each step you take as you perform a series of commands. Macros are recorded in the Visual Basic for Applications programming language. Definition: *macro: - An action or a set of actions that you can use to automate tasks. For more details, consult the actual Excel 2003 help file on this topic. This topic provides an overview on recording and running macros in Excel. For example, if you often enter long text strings in cells, you can create a macro to format those cells so that the text wraps. A macro is a series of commands and functions that are stored in a Microsoft Visual Basic module and can be run whenever you need to perform the task. If you perform a task repeatedly in Microsoft Excel, you can automate the task with a macro. Creating a *Macro in Excel 2003 Excel 2003 Microsoft Help Topic About macros in Excel