Microsoft Office Development and Consultancy

Excel

Display the Customise dialog box

It is possible to change your custom button image to something other than a smiley face.

Select (View > Toolbars > Customise) or alternatively select (Tools > Customise).

Another quick way to display this dialog box is right mouse click on any toolbar and select "Customise" at the bottom.

You can only manipulate your toolbars and menus while this dialog box is displayed.

Change the image on your button

Right mouse click on the button and select Change Button Image sub menu.

This will display a choice of 42 images that you can use. Select the image you would like.

 Shortcut menu when you right click on a custom button

Using the Button Editor

An alternative to using one of the pre-defined icons is to draw your own.

Select Edit Button Image to display the "Button Editor" dialog box.

Each square represents a pixel which are the units of resolution used by your screen.

The Preview area displays the image as it will appear on your toolbar or menu.

 Edit Button Image dialog box

You make a mess of your image you can always reset it back to its default by pressing Reset Button Image.

If you only want to display text, and sometimes this is more appropriate you can select "Text Only (Always)".

For more information about changing your command button options please refer to the Advanced Techniques page.

Copying Button Faces

You can also copy a button image from an existing button.

Select the button that has the image you would like to copy and select Copy Button Image.

Select to your new button and select Paste Button Image.

Changing the FaceID

You can also change your button image using the Immediate window or dynamically from within VBA Code.

This only needs to be run once.

Changing the Tooltip text

The default tooltip text for a custom button which only displays an image is whatever text is displayed in the Name box.

For custom buttons this will default to "&Custom Button".

This can be run from the Immediate window or dynamically from within VBA Code.

This only needs to be run once.

Have a much greater selection of images

There are actually thousands of possible icons that you could use for your buttons.

There is an Excel add-in that can be downloaded specifically to let you choose from the wide range of possible icons.

Please refer to the FREE Excel add-ins page for more details.