Leading the way in Microsoft Office Development

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.

A lot of the built-in commands have an image associated with them.

There is no button associated with macros that you have written yourself.

 Shortcut menu when you right click on a custom button

Several of the commands on the properties drop-down menu are specific to handling button images:

Copy Button Image - Copies the current image to the clipboard. This allows it to be pasted into external programs and modified.

Paste Button Image - Pastes the current clipboard entry as the new image for the command button. Buttons should be 16 * 16 pixels in size to avoid any distortion.

Reset Button Image - Resets the command button image back to its default.

Edit Button Image - Displays the Button Editor dialog box which allows you to edit the colour of the individual pixels.

Change Button Image - Displays an extension bar which contains 42 sample buttons to choose from.

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.

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

Select one of the colours and click the Colour Palette to select the colour.

To remove a colour, you can click the erase button.

The move arrows move the entire image in a particular direction. This is useful when you create an image and realise that it is not centred.

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

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 our Free add-ins page.