Create an addin and store it there.

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


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"GM" wrote in message
...
I have this function which I think that I found here. What I want to do is
make this function global so that it can be used in any workbook or
worksheet. So the question is how can I make this happen.

Function DocProps(prop As String)
Application.Volatile
On Error GoTo err_value
DocProps = ActiveWorkbook.BuiltinDocumentProperties _
(prop)
Exit Function
err_value:
DocProps = CVErr(xlErrValue)
End Function


TIA
GM