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.

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.

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)

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.

--

Dave Peterson

Thank you both! Both perspective were interesting and helpful.

"Dave Peterson" wrote:

> 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)
>
> 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.
>
> --
>
> Dave Peterson
>

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

Regards
Jorge

"Dave Peterson" wrote:

> 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)
>
> 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.
>
> --
>
> Dave Peterson
>