Locking cells in a shared workbook

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!
 
S

Sean Timmons

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...
 
G

Gord Dibben

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

Sharing workbooks limitations - Merged Cells 12
Shared Workbook Locked 2
Cells Locking? 7
new cells in excel default to locked? 3
Lock cells in a shared workbook 1
Unprotecting worksheets 2
corrupted shared excel workbook 1
Scope priviledges for locked/unlocked cells 2

Top