How did you create that custom button? Did you add it to a toolbar?

If you did....

Your life will become much simpler if you include code to create the toolbar
when the workbook is opened and include code to destroy the toolbar when the
workbook is closed.

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

wrote:

Hi, I have previously distributed an Excel 2003 file that contained a
Macro which the user could run on the spreadsheet. That worked fine.

Now, I have added a custom button which will run that same macro when
selected (It would save the users the time of selecting tools /
macros / run)

The problem is that when the user opens the new file I emailed with
the button, the button does not appear.

Do you know how I can save a custom button or custom shortcut menu so
that it is available to all users who open this file?

What options do I have to make this custom functionality available to
all users (aside from giving instructions on how to create the custom
button / menu from scratch?)

It appears the custom button functionality is saved to my local
machine / Excel application (as opposed to being saved in with the
file which I distributed)

Thanks,

--

Dave Peterson