Permissions  
Author Message
barnardm0





PostPosted: Wed Dec 19 08:57:14 CST 2007 Top

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.

Excel387  
 
 
Stephen





PostPosted: Wed Dec 19 08:57:14 CST 2007 Top

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.



> 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.


 
 
Gaurav





PostPosted: Wed Dec 19 08:59:47 CST 2007 Top

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




> 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.