application.calculatebeforesave = false

or something like that... as always since this is an application level
setting make sore to use an errorhandler to reset the value in case of a
crash.
--
HTH...

Jim Thomlinson


"Andy" wrote:

I am using Excel via automation with vba and handling sheet calculate
events to handle changes made to the sheet. However, following a saveAs
for the workbook a sheet calculate event occurs for all the sheets. Is
there a way I can prevent this from happening.

Thanks