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

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)

"QUESTION-MARK" wrote in message
ups.com...
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

http://office.microsoft.com/en-us/as...872961033.aspx

Vaya con Dios,
Chuck, CABGx3



"QUESTION-MARK" wrote:

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