View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Custom Button and End Users

hi,
custom toolbar icons(buttons) apply only to the pc being customized as does
all customizations. It does not apply to files or other PCs.
you can customize someone else PC with a macro but doing so without the
other persons knowlege or permission is considered impolite(you may be
altering their cumtomizations) and many consider this action as a virus.
you can copy you icon(button) and distribute it to your users but this is a
hassel for all parties.
A worksheet command button is about your only workable alternative. It is an
object assigned to the sheet and will travel with the file.
sorry.
regards
FSt1

"Filo" wrote:

Is it possible to customize a button in a toolbar (the button will start a
macro in the the workbook), and make it available to end users when they open
the spreadsheet? I created the button on my PC, but when I emailed an end
user the spreadsheet he did not see the button...

If it is not possible through the toolbar, is a worksheet button the only
other alternative?

Thank you for any help.