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

A comprehensive recipe can be found he

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

--
Kind regards,

Niek Otten

"praveen_khm"
wrote in message
...

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

Niek,

I am sorry, I could not make out how should the excel be saved. I don
have a problem in creating the Macro again but I do not understand
coding. So I do not use the VB script. I ll prefer redoing it. Please
let me know how do I save it when creating Macro.

Thanks for your response.

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

Niek,

I am sorry, I could not make out how should the excel be saved. I don
have a problem in creating the Macro again but I do not understand
coding. So I do not use the VB script. I ll prefer redoing it. Please
let me know how do I save it when creating Macro.

Thanks for your response.

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