All sheets calculate after saveas
 

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

All sheets calculate after saveas
 

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

All sheets calculate after saveas
 

thanks

I tried that, now the saveAs is fast, but next time I write a change to
a cell, all the sheets are calculated. This doesn't happen after a
save, just a saveAs.

All sheets calculate after saveas
 

I am not 100% sue what is going on there... Check out this link for
calculation secrets. There might be something in here to help you...

http://www.decisionmodels.com/index.htm
--
HTH...

Jim Thomlinson


"Andy" wrote:

thanks

I tried that, now the saveAs is fast, but next time I write a change to
a cell, all the sheets are calculated. This doesn't happen after a
save, just a saveAs.