I have a worksheet/workbook which is used by different Cashiers to summarise
their daily Bankings at the end of each. The worhsheet has columns on which
data is entered and totals are calculated in one column where I have put
formulae. I often have problems with some Cashiers who erroneuosly errase
fumulae by touching wrong buttons. how do I protect the cells which have
formulae so that no one type in anything to avoid errasind the formulae?

Select the cells that should be able to be changed and do:
format|cells|Protection tab|uncheck locked

Select the cells that should not be able to be changed (formulas/titles/etc):
format|cells|Protection tab|check locked

Then protect the worksheet.
tools|protection|protect sheet

This password can be broken quite easily--so don't depend on this to stop users
from finding stuff you don't want found!

And be aware that lots of stuff is disabled if you protect the worksheet. You
may want to test it to see if it's too restrictive for your purposes.


Abraz wrote:

I have a worksheet/workbook which is used by different Cashiers to summarise
their daily Bankings at the end of each. The worhsheet has columns on which
data is entered and totals are calculated in one column where I have put
formulae. I often have problems with some Cashiers who erroneuosly errase
fumulae by touching wrong buttons. how do I protect the cells which have
formulae so that no one type in anything to avoid errasind the formulae?

--

Dave Peterson