Freeze cells from further calculation?
how about copying the values to another cell?
-----Original Message-----
Is there a way to stop a formula from calculatiing at a
given time? I have
a range of cells that I want to be able to click a button
to Freeze the
results. I don't want to lose the formulas though.
The best scenario would be a button to freeze and
unfreeze (toggle)
calculation of the particular range (or sheet) without
affecting the
calculation of other ranges or sheets.
as usual, any help is greatly appreciated.
Jonco
.
|