| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
why do some cells not lock?
I have a worksheet where most of the cells are locked. Users are able to
select only a few 'unlocked' cells to input data. 2 of the cells will not 'lock'. When you open the format for each of those cells, it shows that it is locked but after you protect the document and go to use it, these 2 cells are not locked and the user can change the data and erase the formula. Has anyone encountered this problem before and found any solution? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lock cells. | Excel Discussion (Misc queries) | |||
| How lock just some cells | New Users to Excel | |||
| How To Lock Cells | Excel Discussion (Misc queries) | |||
| Lock all cells? | Excel Discussion (Misc queries) | |||
| How do I lock all cells in a given row together to one another? | Excel Discussion (Misc queries) | |||
Threaded Mode
