Hi Hemant,

If you save the function in your Personal.xls, it will be available to all
open workbooks.

Alternatively, save the function in an add-in.

See Jan Karel Pieterse's excellent tutorial at:

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


---
Regards,
Norman



"Hemant_india" wrote in message
...
hi
i have written a function which i want to use
whereever i need to use in excel
how can i save such macro?
--
hemu