Thread: Workbook Slow
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Karen53 Karen53 is offline
external usenet poster
 
Posts: 333
Default Workbook Slow

Hi,

I find my program execution is quite slow and I suspect it is because of the
Worksheet_Calculate routine. Is there a way to have Worksheet_calculate
programatically run only once instead of once for every change that was made?
Also, have it run only on the sheet the change impacted?

I already have Application.Screenupdating set to false and
Application.EnableEvents set to false

--
Thanks for your help.
Karen53