More Macro Tasks

This lesson teaches you how to record a relative reference macro, assign a keystroke to a macro, copy a macro from another workbook or template, and delete workbook macros.

Questions

• How do you record a relative reference macro?
• How do you run a relative reference macro?
• How do you assign a keystroke to a macro?
• How do you copy a macro from another workbook or template?
• How do you delete workbook macros?

Answers

To record a relative reference macro, choose your active cell and click the Use Relative References button before you begin recording.

To run a relative reference macro, first make sure that the active cell is chosen such that the cells that you want the macro to run on are in the correct relative position.

To assign a keystroke to a macro, open the Macro dialog box and click the Options button. In the Options dialog box, select the Shortcut key option and enter the keystroke combination you want to use.

To copy a macro from another workbook or template, open the workbook or template that contains the macro you want to copy. In the Macro dialog box, select the macro and click the Copy button. Then, open the workbook or template where you want to paste the macro and click the Paste button in the Macro dialog box.

To delete workbook macros, open the Macro dialog box and select the macros you want to delete. Then, click the Delete button.