Protecting formulas in workbook
 

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?



--
Lynne Mawson
Manchester

Protecting formulas in workbook
 

Perhaps a trip to the help index for PROTECTION could be of assistance

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Lynne Mawson" wrote in message
...
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?



--
Lynne Mawson
Manchester

Protecting formulas in workbook
 

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.