One Sheet Manual Calculation

**oOarthurOo** · 04-19-2010, 01:28 PM

Would it be possible to turn it on and off based on which worksheet is activated?

E.g., Activating sheet one would turn on automatic calculation. Activating sheet two would turn it off. Switching back would turn it back on.

Hope it's ok to wake up this old thread.

**shg** · 04-19-2010, 01:55 PM

oOarthurOo, time to get reacquainted with the forum rules, and then start your own thread,

**oOarthurOo** · 04-19-2010, 02:11 PM

At the time of posting, I was aware of rule 2:

Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.

I decided it was likely appropriate to post in the thread since I have a suggested solution. Granted, not certain if the idea will work, thus phrased it as a question. But this is what I had in mind:

Private Sub Worksheet_Activate()
Application.Calculation = xlCalculationManual
End Sub

Private Sub Worksheet_Deactivate()
Application.Calculation = xlAutomatic
End Sub

Of course, I will defer to your (or other mods) judgement on whether this comment requires a new thread.

**shg** · 04-19-2010, 02:16 PM

You can always post recommended solutions in a thread, but it's unlikely the OP is stopping back 15 months later (to the day, as it turns out) to check.

The correct constant is xlCalculationAutomatic, not xlAutomatic.