#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 16
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 364
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 207
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Permissions will07 Excel Discussion (Misc queries) 1 November 23rd 07 02:49 AM
Protection permissions. Paul Excel Discussion (Misc queries) 0 November 23rd 06 11:53 AM
Permissions Paul Excel Worksheet Functions 0 November 23rd 06 10:58 AM
Excel Permissions James A Excel Discussion (Misc queries) 1 September 23rd 06 01:49 AM
Problems with permissions... Corey Excel Discussion (Misc queries) 0 July 5th 06 03:12 PM


All times are GMT +1. The time now is 03:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"