Protected Cells

  • Thread starter Thread starter JCO
  • Start date Start date
J

JCO

Is there a way to protect certain cells, in a spreadsheet, so that the user
cannot modify (destroy) the formulas?
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.
 
Yes this works great... thanks.

JW said:
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.
Click to expand...
 
Back
Top