View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Echo[_2_] Echo[_2_] is offline
external usenet poster
 
Posts: 7
Default How to stop all Excel funtions for a period

Setting the calculation to manual at the start of the Macro might work.
Try this:

Application.Calculation = xlCalculationManual