Maybe...

If you're using xl2002+ (I think), look at VBAs help for:
EnableCalculation

And read the warnings, too.

caroline wrote:

My macros need the calculation to be set on automatic.
But one of the sheets calculation is taking too long, so ideally I would
like NOT to calculate on that sheet ONLY unless I activate it.
Is there a way to do this?
Thanks

--
caroline

--

Dave Peterson