| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect sheet with permissions?
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Protect sheet with permissions?
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 "LiveUser" wrote: 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Protect sheet with permissions?
Thank you.
"CLR" wrote: 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 "LiveUser" wrote: 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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Protect sheet with permissions?
You're welcome, thanks for the feedback..........
Vaya con Dios, Chuck, CABGx3 "LiveUser" wrote: Thank you. "CLR" wrote: 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 "LiveUser" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Bug - Protect Sheet ? | Excel Discussion (Misc queries) | |||
| How to protect all sheet ? | Excel Worksheet Functions | |||
| Protect Workbook Vs Protect Sheet | New Users to Excel | |||
| Can I protect columns w/in a "List" using Protect Sheet? | Excel Discussion (Misc queries) | |||
| help with protect sheet | Excel Discussion (Misc queries) | |||
Linear Mode
