Thread: Protect
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default 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