Protect

  • Thread starter Thread starter roman99
  • Start date Start date
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].
 
If you are only concerned about the F9 key then you could disable F9 :

Private Sub Worksheet_Activate()
Application.OnKey "{F9}", ""
End Sub

Joerg
 
Depending on the version of excel you're using, each worksheet can have its
calculation set via code.

workbooks("someworkbook.xls").worksheets("somesheet").EnableCalculation = false

xl2003 has this feature. I'm not sure if it was added in xl2k or xl2003,
though.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Custom Function Won't Auto-Calculate 5
difference between Alt-Control-Shift-F9 and Ctrl-H Replace = with 2
Unlocking Admin passwords by using....? 5
Recalculation does not work 8
paste values 3
recalculation not recalculating some cells containing user functio 2
Excel recalculation problem 4
Calculation notation 1

Back
Top