While the Caption property is a simple text box where you can type a new caption, many choices lead to fly-out menus or even to new dialog boxes. Note that you can change the appearance of the button by using properties such as BackColor, ForeColor, and Font. Click in the second column of the Properties dialog, next to the word Caption, and type the words that should appear on the button ( Figure 110).
Click the second button, the Properties button, to display the properties for the button. Design mode must be on to work with the button. When you exit Design mode, the button you create acts as a button when you click on it. Design mode has to be on when you are working with this control. Design Mode is the icon in the top left, with the ruler, triangle, and pencil. Notice in Figure 109 that the Design Mode icon is turned on when you draw a new control. Click the Button icon and drag in the worksheet. Select View, Toolbars, Control Toolbox. Follow these steps to build one in Excel 2003: Right-click the button and choose Assign Macro to change the macro assigned to the button.Īn ActiveX button looks like a forms button, but it is more flexible, as you will soon learn. Press Ctrl+1 to edit the font, alignment, size, and more. Otherwise, Ctrl+click the button to select the button. If you are in Text Edit mode, click the diagonal lines surrounding the button to return to the dots border. You can change the font, font size, alignment, and color of the button. The button is now surrounded by diagonal lines. Drag across the words on the button to select them for editing. To change the name: Ctrl+click the button to select the button without running the macro. The button initially appears with the generic name Button 1. The Insert dropdown then offers the forms button. If you can’t find the Developer tab in Excel 2007, use Office Icon, Excel Options, Popular, Show Developer Tab in the Ribbon. Drag a rectangle on the worksheet to draw your button. Open the Insert dropdown and choose the icon shown in Figure 108. This is how you create the forms button in Excel 2003 and earlier. Click the Button icon ( Figure 107) and then drag in the worksheet to draw a button. To run a macro from a forms button, in Excel 2003, select View, Toolbars, Forms. You can run a macro from any of these elements. 
All of them except the custom toolbar translate to Excel 2007.įigure 106.
Figure 106 shows seven different methods in Excel 2003. Solution: There are many ways to run a macro.
Can you run it from a button on the worksheet? Challenge: You want an easy way to run a macro.
0 kommentar(er)
