How to Run a Macro in Excel
We already know the basic method of How to Run a Macro using the Macro Dialog Box. But there are other methods also to run a macro in Excel as mentioned:
Run a Macro from the Ribbon( Developer Tab)
Open the workbook with Macro -> Open the Developer tab in the code group -> click Macros -> Now select the Macro you want to run -> press Run.
Using Keyboard Shortcut
Alt +F11 – This key combination will open the Macro Editor in Excel.
Alt +F8 – This key combination will open the Macro Dialog Box.
Ctrl +Shift + M– This key combination will create a new macro in Excel.
Assign the Macro to a Shape
Click on Insert tab in the Ribbon -> Click Shapes in the Illustrations Group -> Select any Shape ->Draw the Shape -> Right click on the shape and select Edit Text -> Type Run Macro -> Format the Text -> Right click on the Shape -> Select Assign Macro from frop down -> Select the Macro.
How to Record a Macro in Excel
Excel Macro is simply a record button that records a set of actions performed on Excel that can be run multiple times. For example, if you have to format some raw data on a weekly basis you can use a macro to record yourself formatting the data once and let Excel automate the task in the future. it’s used to help users save time and avoid performing redundant tasks.