Automatically run macros
 

I have entered a macro in Visual Basic Editor that has a formula used to
spell out dollar amounts. I am wondering how to get this formula available
in excel at all times. I want anyone to be able to type this formula in any
workbook and it work automatically like the standard formulas. Is this
possible?

Automatically run macros
 

There are two ways:

1. for new workbooks, include the macro in a workbook that you save as
book1.xlt in the XLSTART directory

2. For general use, create an addin and apply it.
--
Gary's Student


"Shirley" wrote:

I have entered a macro in Visual Basic Editor that has a formula used to
spell out dollar amounts. I am wondering how to get this formula available
in excel at all times. I want anyone to be able to type this formula in any
workbook and it work automatically like the standard formulas. Is this
possible?