View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Sharing macros and buttons that accompany the macro

If you want to add an option 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://groups.google.co.uk/groups?th...5B41%40msn.com

JDub wrote:

I have created macros that I wish to share with my co-workers. Also, I have
created custom buttons to accompany those macros. I have been researching
how to share these buttons and macros, but to no success. Is there any way I
can share custom buttons and macros?

I found an export module option in Visual Basic, but am a little hesitant to
try importing anything on another persons computer without knowing it will
work.

Thanks for any help!


--

Dave Peterson