| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking cells in a shared workbook
I have a shared workbook where multiple users will be entering data about
clients. Some columns are calculated based on entered data. I locked the columns that are calculated so they can not be changed, but when I protect and share the workbook the locked cells no longer have the 'locked' effect. Format|Cells|Protection the Locked check box is checked. Can anyone help me with locking cells in a shared workbook? Thank you! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Locking specific cells in a workbook | Excel Discussion (Misc queries) | |||
| Lock cells in shared workbook | Excel Worksheet Functions | |||
| Merging of cells while in shared workbook | Excel Discussion (Misc queries) | |||
| shared workbook keeps locking and "unsharing" - why? | Excel Discussion (Misc queries) | |||
| how to update a shared workbook using the same cells at the same t | Excel Discussion (Misc queries) | |||
Threaded Mode
