LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default Cell locking based on domain user

Hi All,

I try to create a sheet where diferent users from our domain can edit data
only in their own cells. See example below:
A B C D
1 Paul Bill Steve
2 Steve editable
3 Bill editable
4 Paul editable

Goal: When domain user Steve opens the sheet he is only capable to edit cell
D2. If user Bill or Paul open the sheet they can edit only cell C3 (Bill) or
B4 (Paul).

I used online help topic "Allow specific users to edit ranges in a protected
worksheet" from Excel 2007 but it does not work. All three users can edit
eachothers cells.

What am I doing wrong here?

Thanks in advance for helping me out here.

--
Best regards,

Wolter
 
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
How to separate user name and domain name in email id? Harshad[_2_] Excel Discussion (Misc queries) 4 February 17th 09 11:34 AM
2007 Converter wont work as domain user RobGrim Excel Discussion (Misc queries) 0 October 15th 08 11:30 AM
How to group e-mail adresess based on domain name? DavidG Excel Worksheet Functions 2 September 4th 08 06:01 AM


All times are GMT +1. The time now is 10:58 AM.

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"