Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Permissions
Is there a way to give a user permissions for two rows only of a worksheet..
There is nothing that we need them to edit except those two rows. Thank you in advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Permissions
Select those two rows and use
Format Cells Protection tab Remove the tick in Locked and click OK. Then protect the worksheet: Tools Protection Protect Sheet... (and apply a password if you wish). This protects all cells that were "Locked" - that is, everything but the two rows that you unlocked. "Mike Busch" wrote in message ... Is there a way to give a user permissions for two rows only of a worksheet.. There is nothing that we need them to edit except those two rows. Thank you in advance. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Permissions
I think...select those two rows, right click, format cells, under protection
tab uncheck Locked. OK. then Tools, Protection, Protect Sheet, uncheck Select Locked Cells, enter a password, confirm password. OK "Mike Busch" wrote in message ... Is there a way to give a user permissions for two rows only of a worksheet.. There is nothing that we need them to edit except those two rows. Thank you in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Permissions | Excel Discussion (Misc queries) | |||
Protection permissions. | Excel Discussion (Misc queries) | |||
Permissions | Excel Worksheet Functions | |||
Excel Permissions | Excel Discussion (Misc queries) | |||
Problems with permissions... | Excel Discussion (Misc queries) |