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:
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.