Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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) |