Locking cells in a shared workbook

  • Thread starter Thread starter Shacks
  • Start date Start date
S

Shacks

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!
 
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...
 
Share and protect workbook alone does not protect the worksheet.

You must first protect the worksheet.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lock cells in a shared workbook 1
Sharing workbooks limitations - Merged Cells 12
Shared Workbook Locked 2
new cells in excel default to locked? 3
Show Locked Cells 2
Locking cells automatically after enter 2
Copy Worksheet of Locked Workbook 2
Sharing and protecting sections of a worksheet. 1

Back
Top