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