- Click View > Macros > Record Macro.
- Type a name for the macro.
- To use this macro in any new documents you make, be sure the Store macro in box says All Documents
- To run your macro when you click a button, click Button.
- Click the new macro
Shathana. S.R. Answered question