You can *sorta* do that, but it'll take a bit of work. Since you can't set
calculation settings by cell, you have to speicfiy which cells you want to
calculate at certain times. First, Under tools-options-calculation, set
calculation to automatic.

Now, right click on the sheet tab of concern, view code, paste this in.

Private Sub Worksheet_Change(ByVal Target As Range)
'Duplicate/modify following line as needed
If Range("A1") = 5 Then Range("B1").Calculate
End Sub


'Modify this macro, adjusting ranges and values to fit your desire.
Depending on the extent of how many cells you have, this should be able to
give the desired outcome.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Dave Walker" wrote:

I have a worksheet where some cells use the values of other cells to
calculate their value. What I would like to be able to do is turn this
calculation on and off based on another cell value. I'd like to be able to
have the cell either calculate a new value based on the other cells or freeze
the calculation and keep its old value even when the linked cell values
change. Ideally, the freeze/unfreeze would be controlled by another cell
value. This is basically a reversible and automatic version of what you can
do by pasting the value of a formula into a cell.

Is there any way to do this?

Thanks,
Dave