Protected Cells

[JCO]

Is there a way to protect certain cells, in a spreadsheet, so that the user
cannot modify (destroy) the formulas?
Thanks

 

[JW]

Just use regular protection. Before you protect the sheet,
right..click on the cells you want the user to be able to modify and
select Format Cells. Uncheck the Locked box. Now, when you protect
the sheet, only those cells that are unlocked will be able to be
edited.

 

[JCO]

Yes this works great... thanks.

Just use regular protection. Before you protect the sheet,
right..click on the cells you want the user to be able to modify and
select Format Cells. Uncheck the Locked box. Now, when you protect
the sheet, only those cells that are unlocked will be able to be
edited.