Unlock all cells except those containing a formula, or unlock cells to be
used for input by users, keep cells with formula locked, then protect the
worksheet (possibly with a password): Tools/Protection/Worksheets
Regards,
Stefi
€žAllan€ť ezt Ă*rta:
I have created a spreadsheet that has many formulae. The spreadsheet is to be
used by people who do not have a great understanding of Excel.
I wish to protect the formulae so that others cannot overwrite these cells.
Can anyone tell how to protect the cells without having to protect the whole
workbook.
Thanks. Allan
|