View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
bj bj is offline
external usenet poster
 
Posts: 1,397
Default Protecting cells

before you protect ther sheet go to the cells where you are willing to let
them make changes and <format<cells<protection and unprotect those
specific cells.
when you then ptotect the sheet, only these cells can be changed.

"fred" wrote:

Can anyone help me with a problem I have with protecting cells in
Excel. I need to protect the content of some cells but not others and
as far as I can see Excel is all or nothing.
I have a spreadsheet which does some calculations based on data
entered by people with almost no computer knowledge. They keep
entering data in the results cells by mistake and screwing up the
spread sheet. The standard protect cells option appears to allow you
to protect all the cells in a worksheet or non at all.

Any ideas please?