Sharing personal macros and buttons that accompany the macro

[JDub]

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 person’s computer without knowing it will
work.

Thanks for any help!

[goober]

A simple way is to copy the macro into word and then send the word file to your co-workers. They can then copy the code into Excel.

[JDub]

Thanks for that tip, I didn't think about that.

What about the custom buttons that I have made for the macros? Is there an
easy way to send those too?

"goober" wrote:

>
> A simple way is to copy the macro into word and then send the word file
> to your co-workers. They can then copy the code into Excel.
>
>
> --
> goober
> ------------------------------------------------------------------------
> goober's Profile: http://www.excelforum.com/member.php...o&userid=19838
> View this thread: http://www.excelforum.com/showthread...hreadid=485972
>
>

[Dave Peterson]

You have a reply in .misc

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 person’s computer without knowing it will
> work.
>
> Thanks for any help!

--

Dave Peterson