Create and Run a Macro in Excel 2010


When you start up the Excel Application and do a certain number of tasks that you repeat daily, then you can have these tasks saved as a Macro and then simply run the Macro the next time you need to perform these tasks. A macro will record your Mouse clicks and keystrokes and play back at a later time when required.


To Create a Macro

1) Firstly, insert the “Developer” tab in the ribbon of the Excel Application

Refer the article Add the Developer tab to the Ribbon


2) Now, on the “Developer” tab, under the ‘Code’ category, click on the ‘Record Macro’ icon.

Figure 1

3) A ‘Record Macro’ dialogue box appears on the screen. in this dialogue box, give a name for the Macro, specify a short cut key to run the macro later, location where you want store the macro and a brief description about the macro and finally click on the ‘OK’ button.

Figure 2

4) Now, do the necessary tasks that you want on the Excel sheet and the tasks that you perform will be recorded by the Macro. In our illustration we have typed a Welcome message as a Macro.

Figure 3

5) Once you are finished with performing all the tasks, click on the ‘Stop Recording’ icon that you find on the ‘Developer’ tab under the ‘Code’ category.

Figure 4

Run a Macro

1) To Run a Macro that you created above, click on the ‘Macros’ icon that you find on the ‘Developer’ tab under the ‘Code’ category.

Figure 5

2) Now a ‘Macro’ dialogue box appears on the screen which contains a list of Macros in it.

Figure 6

3) Select the Macro that you created from the List and click on the ‘Run’ tab.

Figure 7

4) Now the Macro will be run in the worksheet. You can have the Macro run in any worksheet of the Workbook.

5) You can also run the created Macro by using the Shortcut key that you specified while creating the Macro.

So, I think now you will be familiar to some extent about the creation of Macros in Excel 2010 application.



Read Other Applications