View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RD Wirr RD Wirr is offline
external usenet poster
 
Posts: 55
Default Selective Recalculate

I am looking for a bit of durable code that will help me control the
recalculation in a workbook. I need to turn off the recalculation on two
sheets in a workbook and then recalculate those sheets by activating one of
the worksheets (or I could assign a recalculate button). All other sheets
have to recalculate automatically as usual.

Can anyone help me with this? My VBA skills are pretty much limited to
tweaking what I can get out of the Macro Recorder so any specifics will be
much appreciated.
Thanks,
RDW