| 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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Locking cells in a shared workbook
After you protect the cells using Data Protection Protect Sheet, you can
use Data Protection Protect and Share Workbook. Need to do that first part first, though... "Shacks" wrote: 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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Locking cells in a shared workbook
Share and protect workbook alone does not protect the worksheet.
You must first protect the worksheet. Gord Dibben MS Excel MVP On Tue, 25 Aug 2009 05:36:01 -0700, Shacks wrote: 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! |
| Reply |
| 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) | |||
Hybrid Mode
