Hi Harry,
try this :
. select the whole sheet (top right button to highlight everything)
. right click within the highlighted range
. format cells
. protection
. unlock them all (uncheck the "locked" box)
. click "ok"
you've just unprotected every cell in the sheet
.select the whole sheet (top right button to highlight everything)
. edit (from menu bar)
. goto
. special
. formulas (formulae)
. numbers / text / logicals / error should all be checked
. hit "ok"
you have now selected all the formulae in your sheet
. right click inside one of those highlighted cells
. format cells
. protection
. lock them all (check the "locked" box)
. click "ok"
you've just protected every cell in the sheet
that was highlighted, with the only highlighted cells being those which contain formulae
ergo, your formulae are protected
but we need to protect the sheet in order for this to come into force :
. tools
. protection
. protect sheet
. add a password if you're in Dirty Harry mode today
. click "ok"
try adding numbers to blank cells, should be okay.. now try amending a cell you know to have a formula in it and you should get a "freeze...LAPD" warning