View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Xt Xt is offline
external usenet poster
 
Posts: 49
Default Stopping one sheet from calculating

On Jun 30, 11:20*pm, Dave Peterson wrote:
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


Thanks to you all. Very helpful. xt