Customizing Buttons
Each button on the NVSUSER sheets has a macro assigned to it to perform a function. As delivered, NVSUSER buttons are grouped into Run, View, and Command groups. You can change the groupings and meanings of the buttons. You can also format the button sheet to personalize its color and appearance.
To change the macro, a button is assigned to:
-
Position the mouse pointer over the button (it becomes a hand), but do not click it.
-
Right-click and select from the shortcut menu.
-
Enter the name of the macro you want to run when the button is clicked.
-
Click the OK button to complete the assignment.
Note:
If you have macros that were created using Microsoft Excel 95, the Excel Edit Name dialog box appears when you define the name for the cell in which the macro begins. Select the Command-type option to identify your macro as a Command macro. The Excel Edit Name dialog box does not appear for later versions of Microsoft Excel.