Automatically run macros

S

Shirley

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?
 
G

Gary''s Student

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