designing & installing icon add-in for macro

Hello.

If I have a macro I just wondered how I can design my own small icon
to go in the toolbar, and also how I can install this to work with the
particular macro?

I have Excel 2000.

Thanks for your help

John

Tools|Customize|Toolbars Tab

Maybe create a new custom toolbar??
then click on the Commands tab
Then scroll down the category list. At the bottom, you'll see a category named
Macros.

select that.
Drag that custom button from the Commands (right hand side) box to the new
toolbar.

Right click on it and choose assign macro.
Point at your macro.

Notice all the other stuff you can modify after you've right clicked on
it--including change button image.

Now whenever you click on that icon, excel will find that macro (even open up
the workbook if it has to) and run it.

But I like a method that actually creates an additional option on the menubar
each time the workbook is opened--then cleans up after itself when you close
that workbook.

John Walkenbach has a very nice program that actually adds some items to the
worksheet menubar--it looks very neat and is easy to update. It's his MenuMaker
program:

http://j-walk.com/ss/excel/tips/tip53.htm

(It's especially useful when your list of macros grows.)

John wrote:

Hello.

If I have a macro I just wondered how I can design my own small icon
to go in the toolbar, and also how I can install this to work with the
particular macro?

I have Excel 2000.

Thanks for your help

John

--

Dave Peterson