A comprehensive recipe can be found here:

http://www.jkp-ads.com/Articles/DistributeMacro00.htm

--
Kind regards,

Niek Otten

"praveen_khm" <praveen_khm.21hkly_1137009602.3208@excelforum-nospam.com>
wrote in message
news:praveen_khm.21hkly_1137009602.3208@excelforum-nospam.com...
>
> Hey all,
>
> I have created a Macro and while creating it, have saved it in
> personal.xls. Now, I need to share or send it to others for them to
> work. But it is not working. Also when trying to open in my own pc, a
> new sheet called personal.xls opens and only then it works. Please let
> me know how do I share it. Do i need to create the whole macro again?
> Also I have assigned a macro within a marco. Please help.
> Thanks,
> Pravi
>
>
> --
> praveen_khm
> ------------------------------------------------------------------------
> praveen_khm's Profile:
> http://www.excelforum.com/member.php...o&userid=30364
> View this thread: http://www.excelforum.com/showthread...hreadid=500349
>