Click on it and the Assign Macro dialog will pop up. There are many other options here such as giving a Name to your button, or changing the image.We want click Close when you have made any other changes.
Go here to read the difference between Active X controls and other controls To do this, go to View Control Toolbox to show the Control Toolbox Toolbar, then select the Command Button icon and draw a button on your worksheet.
Note than when you do this the button becomes an embedded Object of the Worksheet Object, giving you greater flexibility and access to many visual properties of the button, by right clicking on the Command Button and choosing Properties.
So decide on your location and to insert a button you need to navigate to the “DEVELOPER” tab on the ribbon, followed by selecting “INSERT” and then select the button icon, as the below image shows: When you have selected the button icon you will notice that the mouse pointer (usually an arrow shape) has now become a cross shape, all you do is navigate to where you want to draw the button, left-click and hold down while you drag the pointer to create a button of your desired size and shape: Now as soon you release the left mouse button a new box will automatically open prompting you to assign a macro to the button, very handy!
This will contain all your saved Macro’s that are in the workbook – all you need to do is select the one that is to be assigned to the button then click on OK.
To do this, go to View Customize and select the Commands tab.
Scroll through the Categories list until you get to the Macros option and select it.Instant Download and Money Back Guarantee on Most Software Excel Trader Package Technical Analysis in Excel With 9.00 of FREE software! Convert Excel Spreadsheets To Webpages | Trading In Excel | Construction Estimators | Finance Templates & Add-ins Bundle | Code-VBA | Smart-VBA | Print-VBA | Excel Data Manipulation & Analysis | Convert MS Office Applications To......The Macro A Macro is a series of commands either recorded, or manually written using the VBA Editor in Excel.Where you want to place this button depends on your report.Sometimes I will have a separate worksheet which just contains the report title, perhaps a few guidelines and then a big “update” button, or other times if the macro I need to user to run is updating a specific chart then I will place it right next to it – common sense is the order of the day here.There are also a number of much quicker alternatives: ASSIGNING A MACRO TO AN OBJECT To assign a macro to an object, select an object from the drawing toolbar, then right click and go to Assign Macro, select the macro you wish to assign, then click OK.(You can double click as well) ASSIGN A MACRO TO A SHORT-CUT KEY Assigning a macro to a shortcut key can be done at the first stage of recording a macro, when your Record Macro dialog first pops up to ask you to give it a name. Note that if you select a shortcut that is already in use (such as Ctrl C for Copy), the original command will be overridden and replaced with your macro.As you will then see on your worksheet, you will have a button with a macro assigned to it: Finishing off The labeling as default will be “Button 1” and we know that’s going to be totally useless to our non-technical users so right-click on the button and select “Edit Text” to change the label to something more appropriate.You can also change the format of the text by right-clicking the button and selecting “Format Control”, this will lead you to the various options that you can alter.Developer Tab | Command Button | Assign a Macro | Visual Basic Editor With Excel VBA you can automate tasks in Excel by writing so called macros. In this chapter, learn how to create a simple macro which will be executed after clicking on a command button. To turn on the Developter tab, execute the following steps. Right click anywhere on the ribbon, and then click Customize the Ribbon. Under Customize the Ribbon, on the right side of the dialog box, select Main tabs (if necessary).