How Do You Record A Macro Using Excel 2000?
Macro Recorder in Excel is a code that allows you to record macros in your program. It works like a tape recorder, but instead of recording phone conversations, it records all of the actions that you perform when you type on your keyboard or use your mouse. For example, you can assign a macro to a button in your worksheet. When you click on the button, you are giving the macro instructions to carry out a particular command. You can also create shortcut keys and assign them to a macro. Macros can be used for actions that are repetitive. Access your Excel 2000 program. Click on the menu bar and choose “Tools,” “Macro” then “Record New Macro.” This opens the Record New macro dialog box. Under “Macro name” type what you would like to name your macro. Click on the text box listed under “description” and enter a description. It is not required to input a description, but it is good to give descriptions to your macros for organizational purposes. Click “OK.” The recording of the macro begins.
