how to attach macros to excel permanently - pawan

[Guest]

I have few macros which I require frequently. I want to attach them to excel
so that whenever I open excel sheet (whether it is new sheet or already
existing sheet). How should I do it?


Thank you
-Pawan

 

[Bob Phillips]

Put them all in a new workbook, save the workbook as an add-in (file type of
xla, at the foot of the list). Then install the add-in, menu
Tools>Add-Ins>Browse.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

There is also the personal.xls file that can store and make available code.

 

[Dave Peterson]

I use a variation of John Walkenbach's menumaker:
http://j-walk.com/ss/excel/tips/tip53.htm
to add items to the worksheet menubar.

 

[Guest]

I have added the add-in....but when I open new worksheet, it doesn't show the
macros in the macro list..