Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding an Auto Exec macro?
Quite an interesting problem.
WorkbookA contains the main routine and consists of 4 sheets. When the routine is run sheet1 and sheet2 are copied and saved to a different drive and emailed to a recipient This is repeated several times. I'd like it so that when the recipients open the file an autoexec macro fires which simply does the following: Sub() Auto_Open Application.Calculation=xlAutomatic End sub Is there a way for me to attach this macro to each of the produced files without programming the VBE (i.e programmatically creating a module and adding in the above macro)? Any help greatly appreciated J |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto adding a macro when Excel 2003 opens | Excel Discussion (Misc queries) | |||
Conditional Formatting Not Immediately Refreshing after Macro Exec | Excel Programming | |||
How to exec a commandbar button while cell in edit mode | Excel Programming | |||
How to exec a commandbar button while cell in edit mode | Excel Programming | |||
Make Exec work properly (error messages on start and exit) | Excel Discussion (Misc queries) |