View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
wdeleo[_2_] wdeleo[_2_] is offline
external usenet poster
 
Posts: 7
Default turn off/on automatic calc upon open/close workbook?

I am giving up on my code ... it runs so damned slow with auto calc on and I
just don't know why. With calc set to manual and calc calls within the code,
all runs well. So ...

Could someone please tell me how I can turn calc to manual upon opening my
workbook and then turn it back to auto upon closing? I need the user to find
it seemless and not a hassle.

TIA
WD