View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mark Mark is offline
external usenet poster
 
Posts: 989
Default 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