One Sheet Manual Calculation

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.

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.