Saturday, June 23, 2012

How to Record a Macro in Excel 2003


1. Open Excel. Either open the program itself or open an existing file.
2. Set your security level. Go to 'Tools > Options.' Go to the Security tab and click on 'Macro Security.' Go to the Security Level tab and change the level to medium or low.
3. Go to 'Tools > Macro.' Choose 'Record New Macro' from the options.
4. Type a name into the macro name box.
5. Type the location of the macro into the box labeled 'Store Macros In.' Click 'OK.'
6. You are ready to begin recording your macro. Perform the series of tasks you would like to create the macro for.
7. When you are finished, click 'Stop Recording' on the toolbar. You may make as many macros as you need.

Blogger news