Protect
Without experimenting, I'm thinking that if you protect from recalculation by
F9, you're basically preventing sheet recalculation at all. Is that your
intent --- to "freeze" the values on the sheet forever?
If so, that can be accomplished by selecting all the cells on a sheet, then
use
Edit | Copy
and while the cells are still selected use
Edit | Paste Special [Values]
That will remove all links and formulas and replace them with their
displayed values, so the sheet definitely won't be affected by the use of
[F9].
"roman99" wrote:
How to propect a worksheet from recalculation by F9?
--
thx
|