Dave Peterson wrote:
I think this capability was added in xl2002.

But you could use something like:

Option Explicit
Sub TurnOffCalc()

Dim wks As Worksheet

For Each wks In ActiveWorkbook.Worksheets
Select Case LCase(wks.Name)
Case Is = "sheet1", "sheet3", "sheet5"
wks.EnableCalculation = False
End Select
Next wks

End Sub

To turn calculation off. (and "= True" to toggle it back on).

(Don't trust your output until you turn it back on for all the sheets--which
should recalc the sheets, too.)

-------

I'll tinker with that some. I'm not philosophically opposed to
upgrading my Excel from 97, I just haven't yet hit a situation where I
needed a new feature. Perhaps I've hit it now and need to reconsider.

Thanks Dave...

Bill