Save the workbook containing the code as an addin (.xla). Then you can load
it under Tools=Addins, use the browse button to find it.

--
Regards,
Tom Ogilvy

DavidObeid wrote in message
...

Thanks gents. One more question. Is there a way to make te UDF
available in other workbooks?


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to
creating financial statements