Using other toolbar button operations

When Excel is in customization mode (that is, when the Customize dialog box is displayed), you can right-click a toolbar control to display a shortcut menu of additional actions. Figure 19-6 shows the shortcut menu that appears when you right-click a button in customization mode.

These commands are described in the following list. (Note that some of these commands are unavailable for certain toolbar controls.)

1 Reset: Resets the control to its original state. 1 Delete: Deletes the control. 1 Name: Lets you change the control's name.

1 Copy Button Image: Copies the control's image and places it on the Clipboard.

i Paste Button Image: Pastes the image from the Clipboard to the control.

i Reset Button Image: Restores the control's original image.

i Edit Button Image: Lets you edit the control's image using the Excel button editor.

ii Change Button Image: Lets you change the image by selecting from a list of different button images.

i Default Style: Displays the control using its default style. (For buttons, the default is image only. For menu items, the default is both image and text.)

i Text Only (Always): Always displays text (no image) for the control.

i Text Only (In Menus): Displays text (no image) if the control is in a menu bar.

i Image and Text: Displays the control's image and text.

i Begin a Group: Inserts a divider in the toolbar. In a drop-down menu, a separator bar appears as a horizontal line between commands. In a toolbar, a separator bar appears as a vertical line.

i Assign a Hyperlink: Lets you assign a hyperlink that activates when the control is clicked.

i Assign a Macro: Lets you assign a macro that executes when the control is clicked.

Figure 19-6:

In customization mode, right-clicking a toolbar control displays this shortcut

[Xj Microsaft Excel

Boold

: i] Eile Edit View Insert Format Tools Data Window

i J ä J ' L

I

, ~ t 1 fi A fc

? -j - p -1 i

[ Arid

Reset Delete

IS.! V. -

C6

A

Name: Recipient

E

F

1

Paste Button Image Reset Button Image Edit Button Image... Change Button Image ►

2

3

4

5

E

7

Li

-

1 Default Stvle k

y

Text Only (Always)

Text Only [in Menus)

Image and Text

10

11

12

13

14

Begin a Group

15

Assign Hyperlink ► Assign Macro...

16

17

0 0

Responses

  • Ponto
    How to control the state of a button via other button in vba?
    7 years ago

Post a comment