You would be best of placing the code into your Personal.xls file which will
open whenever Excel is opened.

The code will work on whichever workbook is active.

Or place the code into a new workbook and save as an Add-in which you would load
through ToolsAdd-ins.


Gord Dibben MS Excel MVP


On Thu, 30 Aug 2007 09:22:03 -0700, Tay wrote:

After I have created the NumberAsText in one spreadsheet, how do I enable the
same to be used in other spreadsheet?