Stopping one sheet from calculating

X

Xt

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
 
D

DCG-jaeson

Hi,

Put this first "Application.Calculation = xlCalculationManual" then
"Calculate" after running your macro.

Hope it will help!
~jaeson
 
D

DCG-jaeson

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


Hi!

First use this "Application.Calculation = xlCalculationManual" and in
End "Calculate"

Hope it will help!
~jaeson
 
J

joeu2004

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?

No. Automatic v. manual calculation mode applies to the entire
workbook, not individual sheets. In fact, I believe it applies to all
workbooks open in the same Excel instance.

However, after setting Application.Calculation=xlCalculationManual,
you can use Sheets("sheet1").Calculate to cause one worksheet to
recalculate.
 
D

Dave Peterson

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.
 
X

Xt

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.

Thanks to you all. Very helpful. xt
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top