View Single Post
  #2   Report Post  
JulieD
 
Posts: n/a
Default

Hi

basically you need to protect them ... more specifically you need to
unprotect the cells you want people to get to and then protect the worksheet

to unprotect cells:
choose the cells that you want people to get to (ie not the ones with
formulas in) and then choose format / cells - protection, and untick
locked - Ok

to protect the sheet:
choose tools / protection / protect sheet - add a password in if you wish

note: worksheet protection works on a sheet by sheet basis - so if you've
got more than one sheet you'll need to do it individually for each one

note2: worksheet protection does not stop people deleting sheets - for that
you need workbook protection as well (tools / protection / protect workbook)

hope this helps
Cheers
JulieD

"camalex03" wrote in message
...
I have set up a spreadsheet for the whole year. I want to make the cells
that contain formulas from being changed without a warning of some type.
I
can't understand all the "help" answers. I need lamen terms. Thank you!!