Question

How can we create a macro in a new module?​

Answer 1

• 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 (Normal.

• To run your macro when you click a button, click Button.

• Click the new macro (it's named something like Normal.