View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] rabblerowzer@yahoo.com is offline
external usenet poster
 
Posts: 3
Default 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,