How do I Create Excel Macros Easily?
Excel macros can be quickly created by recording them. Recording the macro lets you record the tasks in real time. Once the recording is done, you can add the macro as a shortcut on the Quick Access Toolbar. You can also access the macro by selecting in from the "Developer" tab. By default, the "Developer" tab is hidden so you have to unhide it to gain access to the macro selection feature.
Other People Are Reading
Instructions
-
-
1
Display the Developer tab by opening Excel 2007. Select the "Office" button and select "Excel Options." In the "Popular" tab, check the options for "Show Developer Tab In The Ribbon." The tab is now present in the ribbon.
-
2
Plan your macro beforehand. Decide what actions you want to record and how this macro will simplify the task or process.
-
-
3
Create your macro by clicking on the "Record Macro" button on the "Developer" tab. The Macro dialog box appears. Type a name for your macro in the "Macro Name" field. Pick the location to store your macro. To make it available for all workbooks in Excel, select "Personal Macro Workbook." Type a detailed description about your macro in the "Description" field. Click "OK." Once the button is pressed, Excel is recording your actions. Complete the actions you want recorded by the macro. When you are done, click the "Stop Recording" button.
-
4
View or run the macro from the "Developer" tab by selecting the "Macros" button. The Macros dialog box will appear. Run the macro by clicking on the "Run" button. View the visual basic code behind the macro by clicking on the "Step In" button.
-
5
Add a shortcut for the macro to the Quick Access Toolbar by clicking the right drop down list. Select the "More Commands" button. Change the "Choose Commands From" to "Macros." Click on the macro and select "Add." Click "OK." You now have access to the macro from the Quick Access Toolbar and the Macro menu on the "Developer" tab.
-
1
References
- Photo Credit keyboard image by red2000 from Fotolia.com
