Making Macros Available in All Workbooks

[QUESTION-MARK]

Good morning.

I have a simple little query that I want to be available in all
workbooks. I was told that I should put the macro in a module within
Personal.xls. I searched my harddrive and I don't have a Personal.xls
file.

How can I make my macro available for all workbooks?

Thank you,
Mark

 

[Bob Phillips]

Put them in an add-in.


http://support.microsoft.com/default.aspx?kbid=211563
How to create an add-in file in Excel 2000

http://support.microsoft.com/default.aspx?kbid=156942
XL97: How to Create an Add-in File in Microsoft Excel 97


--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

 

[Guest]

http://office.microsoft.com/en-us/assistance/HA010872961033.aspx

Vaya con Dios,
Chuck, CABGx3