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

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.


"Thyagaraj" wrote:

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