Dormant Worksheet

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

Hi -

This sounds like a weird question (even to me).

Is there a way to "turnoff" a worksheet from updating?

So I have a workbook with 10 worksheets and I want 9 of the 10 to be "on"
and update all of the time, but the 10th worksheet to only update when I ask
it to.

Basically, I want to be able to save processing time ... ignore the 10th
worksheet until the "switch" is turned on so that it updates.

Thanks for any suggestions,
Mark
 
ActiveWorkbook.Worksheets("DormantSheet").EnableCalculation = False

toggle true/false to update and turn back off

Regards,
Peter T
 
Peter -

That's perfect ... calculation at the sheet level.

I'll give it a shot and let you know how it works for me.

Mark
 
Perfect.

Thanks,
Mark

Peter T said:
ActiveWorkbook.Worksheets("DormantSheet").EnableCalculation = False

toggle true/false to update and turn back off

Regards,
Peter T
Click to expand...
 
Back
Top