Hi Thyagaraj,

See Jan Karel Pieterse at:

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

To add your macros to the Worksheet Menu bar, see John Walkenbach at:

http://j-walk.com/ss/excel/tips/tip53.htm


---
Regards,
Norman



"Thyagaraj" wrote in message
oups.com...
I have created many macros to automate many things what i do day to
day.
I know how to assign a macro to a button.

But I dont know how to make available all the macros when ever the
excel is opened by any body.........!


Thanks in Advance


Regards
Thyagaraj