Protecting formulas in workbook

  • Thread starter Thread starter Lynne Mawson
  • Start date Start date
L

Lynne Mawson

I'm very new to Excel and have taken a long time to work out some formulas in
a workbook. This book is shared by people who have little or no knowledge at
all of Excel. They are required to input data but sometimes, when an error
is made, a formula is accidentally deleted in one of the columns. Is there
any way I can protect parts of the worksheet and not others?
 
Hi Lynne,
By default, all cells are set to locked. In the FORMAT menu, select CELLS.
In the Format dialog box that pops up, select the PROTECTION tab, and you
will see that the current selected cell is locked. This is so for all cells.
This means that when you protect the sheet (TOOLS > PROTECTION > Protect
Sheet) all the cells will be locked, and no-one can make any changes,
anywhere.
So, select all the cells you want other users to access, unlock them as
above, then protect the sheet.
Now if someone tries to over-write a formula, they'll receive a message
telling them they can't.
Hope this helps
Regards - Dave.
 
Back
Top