ActiveWorkbook.Worksheets("DormantSheet").EnableCa lculation = False

toggle true/false to update and turn back off

Regards,
Peter T

"Mark" wrote in message
...
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