Dormant Worksheet
 

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

Dormant Worksheet
 

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

Dormant Worksheet
 

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

"Peter T" wrote:

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

Dormant Worksheet
 

Perfect.

Thanks,
Mark

"Peter T" wrote:

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