| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't protect some cells in Excel 2003
I locked all cells in an Excel spreadsheet then protected the sheet. Some of
the sheet is set up as a form for users to fill in details and these cells still allow editing which is fine. The problem is that one section of formulas also allows editing. Does anyone know what else could be allowing them to be edited? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can't protect some cells in Excel 2003
Solved it. Someone had added the cells using the Allow users to edit ranges
option. I just had to remove all references to the cells in question. "JMC" wrote: I locked all cells in an Excel spreadsheet then protected the sheet. Some of the sheet is set up as a form for users to fill in details and these cells still allow editing which is fine. The problem is that one section of formulas also allows editing. Does anyone know what else could be allowing them to be edited? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excell VS Office | Excel Discussion (Misc queries) | |||
| How can I protect cells in Excel 2000? | Excel Worksheet Functions | |||
| Excel 2003 will not display color fonts or color fill cells | Excel Worksheet Functions | |||
| Everytime I need to format cells or text, Excel 2003 takes a lot of time or free | Excel Discussion (Misc queries) | |||
| Excel 2003 - cells in formula? | Excel Discussion (Misc queries) | |||
Linear Mode
