View Single Post
  #4   Report Post  
Old June 29th 11, 09:10 PM posted to microsoft.public.excel.worksheet.functions
joeu2004 joeu2004 is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
Posts: 2,059
Default Stopping one sheet from calculating

On Jun 26, 7:32*pm, Xt wrote:
Is there a way to turn the calculation of a particular
sheet off and on using VBA while the VBA is working with
data from another sheet?


No. Automatic v. manual calculation mode applies to the entire
workbook, not individual sheets. In fact, I believe it applies to all
workbooks open in the same Excel instance.

However, after setting Application.Calculation=xlCalculationManual,
you can use Sheets("sheet1").Calculate to cause one worksheet to
recalculate.