Best Way to Share Custom Buttons?
 

What would be the best way to share custom Excel buttons that are linked to
VBA macros with the least possible amount of end-user effort?

Thanks,
Anony

Best Way to Share Custom Buttons?
 

What do you mean by custom buttons? If you mean toolbarbuttons you can just
have them built in with your code.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Anony" wrote:

What would be the best way to share custom Excel buttons that are linked to
VBA macros with the least possible amount of end-user effort?

Thanks,
Anony

Best Way to Share Custom Buttons?
 

I'd add some options to the menu bar or build a toolbar that allows the user
easy access to the macros.

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)

Anony wrote:

What would be the best way to share custom Excel buttons that are linked to
VBA macros with the least possible amount of end-user effort?

Thanks,
Anony

--

Dave Peterson