Protect sheet with permissions?

  • Thread starter Thread starter LiveUser
  • Start date Start date
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.
 
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
 
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
 
You're welcome, thanks for the feedback..........

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

Back
Top