Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PROTECTING FORMULAS | Excel Discussion (Misc queries) | |||
Protecting my formulas | Excel Discussion (Misc queries) | |||
Protecting formulas in a workbook | Excel Worksheet Functions | |||
Protecting Formulas | New Users to Excel | |||
Protecting formulas | Excel Discussion (Misc queries) |