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

[Irina]

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
>
>