Custom Button and End Users

[Guest]

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.

 

[Guest]

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

 

[Dave Peterson]

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)

 

[Guest]

Thank you both! Both perspective were interesting and helpful.

 

[Guest]

Thanks Dave, I found Debra's site extremely useful.

Regards
Jorge