web analytics

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

Microsoft Excel 2013

This article will show you how to automate commands in Microsoft Excel 2013 with Macros. Macros automate the excel worksheet by enabling you to record complex command sequences. The Excel status bar located at the bottom of the Microsoft Excel 2013 window contains a record macro button. What you should do is to click this button in order to turn on the macro recorder. The view tab contains a macros command button and the drop down menu has an option for recording macro.

1

After you turn on the macro recorder it will record all of your actions in the active worksheet organization chart sheet after you create them.

All of the macros that you will create with the help of the macro recorder can be stored as part of the current workbook, in a new Excel workbook or in a specially designed personal macro workbook that is available worldwide, named personal.xlsb has to be stored in a folder on your hard drive under the name Excel Start.

2

After you create a macro with the macro recorder you decision makes up not just the workbook in which to store the macro, but also what name shortcut key strokes to assign to the macro that you are creating. If assigning a name for your macro, you should use the same guidelines that you use when you assign a standard range name to a cell range in your worksheet.

In order to see that is a piece of cake to create a macro with the macro recorder, just go through all the steps needed for creating a macro that enters the company name, centres  the company name across rows A through E with the merge in centre feature and fills the cells with the selected color.

Just open the Microsoft Excel workbook that has the worksheet data or chart you want your macro to work with. Now, just click on the record macro button located on the status bar. You can enter the macro name, define any keystroke shortcuts, select the workbook in which to store the macro and enter a description of the macros function.

3

Now, just replace the temporary macro name by entering your name for the macro in the macro name text box, click the personal macro workbook, new workbook or this workbook option on the store macro in dropdown list to indicate where to save the new macro.

Continue reading in PART 2.

Leave a Reply