Sometimes, while working in Microsoft Excel, you may be performing the same actions over a long period of time. In this case, it is best to use macros (sequences of actions you create) that you can add to any document and use them to perform repetitive tasks. So, in order to create a button that launches a macro, you need to follow these steps.
Instructions
Step 1
First go to the "View" section on the toolbar, and then click on the "Macros" item. In the list that opens, select "Record Macro …".
Step 2
Next, in the new "Record Macro" window, you need to fill in three fields:
• In the "Macro name" field, you must specify a name that will be displayed in the list of other macros. Remember the name you entered, because it will still come in handy for us.
• From the Save In list, select Personal Macro Book. This will allow you to use this macro in any document.
• In the "Description" field, write a short summary of this macro, for example, list the commands that it executes.
After you fill in these fields, save the settings by clicking "OK".
Step 3
Start recording your macro. To do this, follow in a certain sequence those actions that should be automatically played when you click on the button you are creating. Once you have finished recording your actions, repeat Step 1 and select Stop Recording.
Step 4
Next, by clicking on the "Office Button" (in the upper left corner), open the "Customize Quick Access Toolbar" window.
Step 5
In the "Settings" tab, from the list, select "Select commands from" and the item "Macros".
Step 6
On the left, click on the name of the macro you created (in our case it will be called PERSONAL. XSLB! XXXXX, where XXXXX is the name entered in the second step) and click the Add button. As a result, the name of the macro should be copied to the right window, save the settings by clicking "OK".
Step 7
If you did everything correctly, a button will appear in the quick access panel, which, when clicked, will run the created macro.
