Sharing personal macros and buttons that accompany the macro
 

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!

Sharing personal macros and buttons that accompany the macro
 

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

--
goobe
-----------------------------------------------------------------------
goober's Profile: http://www.excelforum.com/member.php...fo&userid=1983
View this thread: http://www.excelforum.com/showthread.php?threadid=48597

Sharing personal macros and buttons that accompany the macro
 

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

Sharing personal macros and buttons that accompany the macro
 

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 persons computer without knowing it will
work.

Thanks for any help!

--

Dave Peterson