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!!
|