Creating Custom Icons

Brett points out that Excel has a rudimentary icon editor. Right click on a toolbar button and choose Customize to enter Customize Mode. Then right click on the button again and choose Edit Button Image…

Customicon1

You get a 16 x 16 grid in which you can create your own icon. Here’s one that I created for my dictionary add-in. It’s supposed to be a book with the world behind it.

Customicon2

If you use this method to create your own icons, take a look at how some of the built-in icons look in this editor. It will give you some ideas on how to create yours.

4 Comments

  1. Andrew:

    Hi Dick,

    Andy Pope has a great Button Editor add-in.

    http://www.andypope.info/vba/buttoneditor.htm

    Highly recommended!

  2. Matt H:

    Hey Dick,

    No offense, but what is your icon supposed to look like?!? :)
    Matt

  3. Dick:

    Matt: None taken. It’s supposed to be a book (i.e. dictionary) with the world (i.e. world wide web) behind it.

  4. Matt H:

    OK, I see it now.. :)

Leave a comment