Running a macro is similar to choosing a command in Excel. When you record or edit the macro, you have the choice of making it available through a menu command, a keyboard combination, or even a toolbar button. As with other options in Excel, your choice depends on your personal preferences ”and you can choose to make more than one option available. Where you store a macro when you save it determines its availability later. Macros stored in the Personal Macro workbook are always available, and macros stored in any other workbooks are only available when the workbook is open .
Run a Macro Using a Menu Command