Can anybody help on Vb Macros please..?

[Thyagaraj]

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

 

[Norman Jones]

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