4. To assign a macro to the button, click the View Code button on the Control Toolbox (second row, left side). This creates a new procedure on the code pane for the current worksheet. Type the code that you want to have run, or the name of the macro you want to run in this procedure. Figure 24.11 shows the code for the button. This code appears on the code pane for the worksheet.

Figure 24.10

Clicking the Properties icon brings up the Properties window, where you can adjust many aspects of the ActiveX button.


0 0

Post a comment