LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default 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?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macros, How do I know what they do if I didn't create them. Abelg Excel Discussion (Misc queries) 1 September 17th 05 05:57 PM
Saving Macros Gerald Excel Discussion (Misc queries) 1 August 19th 05 02:28 PM
Purge macros Don_S Excel Worksheet Functions 1 August 16th 05 03:51 PM
Remove macros from spreadsheet Jan Buckley Excel Discussion (Misc queries) 1 August 12th 05 08:38 PM
Enable macros automatically for a workbook Diane Alsing Excel Discussion (Misc queries) 4 February 16th 05 05:48 PM


All times are GMT +1. The time now is 11:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"