Select the macro that you would like to edit from the list and click the Edit command on the right: First, click the Macros drop-down command, and then click View Macros: Once a macro has been recorded, you can edit it easily in Excel. Once you have completed all of the actions that you need included in the macro, select the Macros drop-down command again, and click Stop Recording:Īt this point the new macro will be complete.
Once the OK button has been selected Excel will then record all of your actions inside the Excel window. When you are ready to record a macro select the OK button. In this dialog, you can choose a name for the macro that you will be recording, where this new macro will be stored, and add a description of its actions to it. To record a macro, click View → Macros → Record Macro: Now you can run this macro to repeat the recorded actions as necessary. When you have completed all the actions that need to be recorded, you will stop recording. When a macro is being recorded, Excel will store any action in the Excel window in the macro that you are creating.
The first step in the creation of a macro is to record one.
0 kommentar(er)
