Convert to Text (XP SP2)

[HansV]

To make macros and custom functions available to all workbooks, they should be stored in a module in the personal macro workbook Personal.xls or in an add-in. Personal.xls is easier; see Legare Coleman's <!post=Personal.xls Tutorial (All),118382>Personal.xls Tutorial (All)<!/post>. As noted before, to use custom functions that are stored in Personal.xls they must be prefixed:

=Personal.xls!NumWord(A1)

The code can be transferred to Personal.xls in two ways:
- By copy and paste, or
- By dragging Module1 from Tony's workbook to Personal.xls in the Project Explorer in the Visual Basic Editor.

[Rebel]

Thanks Hans. Looks like I've got some reading to do this evening.