You can also use a new type of clipart called SmartArt. You can use pre-made clipart to create a "button" for your macro. Running a Macro Using Clipart or SmartArt Again, this should only be done if you've already created your macro and know the properties that you want to use. (Optional) Right-click the button and select "Format Control." In this dialog window, you can assign different properties for your button. You can always assign a macro to a button in the future after you've created the macro you want to use.Ħ. If you have no macros created yet, you won't be able to perform this action. Click the macro that you want to assign to the button. When you place the button, the "Assign Macro" window automatically opens.ĥ. If you misplace the location, you can always choose to move the button's location later. Note that the location you choose will be the upper left corner of the button. Click the location on the spreadsheet where you want the button to display. Click the "Button" item in the dropdown menu.Ĥ. A dropdown menu displays with several form controls you can add to your workbook.ģ. This button is found in the "Controls" group. Click the "Insert" button in the Developer tab. If you don't have the Developer tab enabled, refer to chapter 1 to enable the Developer tab.Ģ. Click the Developer tab or ribbon, depending on your Excel version.
#WHERE TO FIND DEVELOPER TAB IN EXCEL HOW TO#
You don't need to explain to them how to add the toolbar with a button created, so this option makes it much easier for distributed Excel workbooks.įollow these steps to create a custom form control button to your workbook to run a macro.ġ. This button makes it easier for users to run the macro if they don't have the Quick Access toolbar enabled. A custom button is useful when you want to distribute your workbook to other users. You can also create a custom button to run your macro. If you add a macro and the toolbar is hidden, you won't see it after you make these changes. If it's not checked in the customization window, then check it to add the toolbar to your main Excel interface. Click the "Add" button to move it to the right text box, which indicates the macro has been added.Īlso note that you can turn the Quick Access toolbar off or on. Click the macro you want to add to the Quick Access toolbar.ĥ. Click "Macros" in the first dropdown labeled "Choose commands from." This selection should show all of the macros you've created.Ĥ.
Several menu customization options are shown in the center window.ģ. If you run a newer version, click the "File" tab and then click "Options."Ģ. Click the Microsoft Office button and click "Excel Options" if you run Excel 2007. Follow these steps to assign a button to the Quick Access toolbar.ġ.
0 kommentar(er)
