VBA to enable auto calculation after copying worksheet

[nockam]

I have a file that links in several different datasources. What I am doing is updating all my sources, running all my calculations then producing "results" sheets. I have several seperate reports being generated from the same data. I am copying the worksheet into a new workbook then saving, emailing, then going onto the next. Problem is when the users open that file their calculation is set to manual because I am manually calculating everything to speed up processing time. If i enable auto calculation after copying the worksheet it calculates my entire workbook, then saves, and goes onto the next. Each time it auto calculates it takes 15 minutes. With manual calc its 2 minutes. How can i make it so that my main file always has auto calc off but make it so that when users open the seperate file auto calc is enabled?

[nockam]

Nevermind.... Ive been looking for a solution to this for several hours tonight and I finally found something that will work!

Built a module... built in my auto_open macro with the line to enable automatic calcuation.... exported the module then put this in all my reports before it saves them...

Application.VBE.ActiveVBProject.VBComponents.Import ("R:\automatic reports\autocalc.bas")

I hate to say it but MREXCEL gets the credit this time...
http://www.mrexcel.com/tip043.shtml