web analytics

HOW TO AUTOMATE COMMANDS IN MICROSOFT EXCEL 2013 WITH MACROS – PART 2

Microsoft Excel 2013

This is a continuation of PART 1 of this article.

For this example macro, select the personal macro workbook so that you can use it to enter the company name in the any excel workbook that you create or edit. Click on the OK button in order to close the record macro dialog box. Select the cells, enter the data and choose the Excel commands required to perform the tasks that you want. Recorded just as you normally would in creating or editing the current worksheet, using the keyboard, the mouse or a combination of the two. After you are finished recording, just click on the Stop Recording button located in the status bar or the Developer Tab on the ribbon.

To run a recorded macro just click on the View Macros option located on the macros buttons drop-down menu on the View tab or you can just press Alt+F8 in order to open the macro dialog box.

1

Microsoft Excel lists the names of all the macros in the current Excel workbook and in your personal macro workbook only if you have created one.

2

After you have done this, in the macro name list box just simply click the macro name that you want to run and after that just click the Run button or press Enter on the keyboard in order to play back all its commands. If you signed a shortcut key stroke to the macro you don’t have to go through with the process of opening the macro dialog box in order to run the macro. Simply press Ctrl+ the letter key or Ctrl+Shift+ the letter key that you have already assigned and Microsoft Excel will immediately play back all the commands that you have previously recorded. You can assign a macro too accustomed to have on the ribbon and then you can run it just if you click on the custom button you have created. If you want to assign a macro to a custom group on a custom ribbon tab, just choose File, then Options

3

and then click on the Customise button.

4

Now in the Microsoft Excel options dialog box just click on Macros in the Choose Commands from the drop-down list box located on the left side of the window. After this, click on the name of the custom group on the custom tab to which you want to add the macro in the main tabs list box located on the right side of the screen. Now In the Choose Commands from the list box located on the left side of the screen, just click the name of the macro you wish to add to the custom group that is selected in the main tabs list box located on the right of the window. After doing this, click the Add button to add the macro you have selected to the selected custom group on your custom tab and then just click on the OK button in order to close the Microsoft Excel Options dialog box. After you have added a macro to the custom group of a custom tab, the name of the macro appears on a button sporting a generic icon on the custom tab of the ribbon then all you have to do to run the macro his click this command button.

Leave a Reply