Depends on the version of excel you're running.

Look in VBA's help for EnableCalculation.

If you find it (and all the versions of excel that you need to support have
it!), then read the help.




On 06/26/2011 21:32, Xt wrote:
Hi folks.

Is there a way to turn the calculation of a particular sheet off and
on using VBA while the VBA is working with data from another sheet?

Thanks

xt

--
Dave Peterson