Protect sheet with permissions?

L

LiveUser

I want to protect the sheet, but allow for certain users to have permission
to edit certain cells I allow.

I selected the ranges I would like for users to be able to edit, I added
myself as a user, then I protected the sheet.

When the sheet is protected I can't select the cells I wanted for users to
be able to edit while the sheet is protected.

What am I doing wrong?

Thank you.
 
C

CLR

To "free up" cells from the protection........select them > Right-click >
Format Cells > ProtectionTab > uncheck the LOCKED box...........then go back
and Protect the sheet. These cells will be editable, the rest will not.

Vaya con Dios,
Chuck, CABGx3
 
L

LiveUser

Thank you.

CLR said:
To "free up" cells from the protection........select them > Right-click >
Format Cells > ProtectionTab > uncheck the LOCKED box...........then go back
and Protect the sheet. These cells will be editable, the rest will not.

Vaya con Dios,
Chuck, CABGx3
 

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

Top