What is a Macro in Excel
Macros allows automating repetitive tasks in Microsoft Excel. Some tasks need to be performed multiple times and repetition of all the actions would consume time. In such type of Scenarios, Macros helps in automating these tasks.
How to Enable the Developer’s Tool
Step 1: Go to File > Options > Customize Ribbon
Step 2: Then checkmark the Developer’s tool option in the customize ribbon option.
Now you can record Macro, run Macro and do everything that a developer can do.
How to Run a Macro Automatically
To run a macro automatically when the workbook opens one must enable the developer’s tools in Microsoft Excel.
Contact Us