Can anybody help on Vb Macros..?

[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

 

[Guest]

At first, define your functions as public, and if you don't want open the
workbook, containing your macros every time entering Excel, save it
(workbook) as add-ins(xla).
To do it, set IsAddin property of workbook to ON, then save and add-ins it
via menu
Tools-Add-Ins.