distributing an Excel custom button
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,
|