View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.setup
Abraz Abraz is offline
external usenet poster
 
Posts: 2
Default How do I protect selected cells on my worksheet?

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?