View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andy Andy is offline
external usenet poster
 
Posts: 2
Default 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