| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cell locking based on domain user
Hi Wolter
This can only be done using VBA. What code have you written to achieve this? -- Regards Roger Govier "Wolter" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cell locking based on domain user
Hi Roger,
I've done nothing so far in VBA because I believed from the help topic mentioned before that this could be done without. Reading your reply it's not possible without VBA. In that case I have missed the point in the help topic. Best regards, Wolter "Roger Govier" <roger@technology4unospamdotcodotuk wrote in message ... Hi Wolter This can only be done using VBA. What code have you written to achieve this? -- Regards Roger Govier "Wolter" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cell locking based on domain user
Hi Wolter
I apologise. I wrote my response without checking out XL2007 first. As you correctly point out, there is an option to allow the unlocking of locked cells according to different user passwords. I have just created such a list, based upon your example, and it works - as described. Did you remember to Password protect the Worksheet after you had set up the ranges and user passwords? I password protected my sheet, and all worked fine. If you are still having a problem and wish to mail me a copy of your workbook direct, I will take a look To mail direct, send to roger at technology4u dot co dot uk Change the at and dots to make valid email address -- Regards Roger Govier "Wolter" wrote in message ... Hi Roger, I've done nothing so far in VBA because I believed from the help topic mentioned before that this could be done without. Reading your reply it's not possible without VBA. In that case I have missed the point in the help topic. Best regards, Wolter "Roger Govier" <roger@technology4unospamdotcodotuk wrote in message ... Hi Wolter This can only be done using VBA. What code have you written to achieve this? -- Regards Roger Govier "Wolter" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cell locking based on domain user
Hi all,
Send my sample to Roger via regular email. Follow up's will be posted here for the community. Best regards, Wolter "Roger Govier" <roger@technology4unospamdotcodotuk wrote in message ... Hi Wolter I apologise. I wrote my response without checking out XL2007 first. As you correctly point out, there is an option to allow the unlocking of locked cells according to different user passwords. I have just created such a list, based upon your example, and it works - as described. Did you remember to Password protect the Worksheet after you had set up the ranges and user passwords? I password protected my sheet, and all worked fine. If you are still having a problem and wish to mail me a copy of your workbook direct, I will take a look To mail direct, send to roger at technology4u dot co dot uk Change the at and dots to make valid email address -- Regards Roger Govier "Wolter" wrote in message ... Hi Roger, I've done nothing so far in VBA because I believed from the help topic mentioned before that this could be done without. Reading your reply it's not possible without VBA. In that case I have missed the point in the help topic. Best regards, Wolter "Roger Govier" <roger@technology4unospamdotcodotuk wrote in message ... Hi Wolter This can only be done using VBA. What code have you written to achieve this? -- Regards Roger Govier "Wolter" wrote in message ... 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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cell locking based on domain user
Hello Roger,
Will do via separate email. Tnx. -- Best regards, Wolter "Roger Govier" wrote: Hi Wolter I apologise. I wrote my response without checking out XL2007 first. As you correctly point out, there is an option to allow the unlocking of locked cells according to different user passwords. I have just created such a list, based upon your example, and it works - as described. Did you remember to Password protect the Worksheet after you had set up the ranges and user passwords? I password protected my sheet, and all worked fine. If you are still having a problem and wish to mail me a copy of your workbook direct, I will take a look To mail direct, send to roger at technology4u dot co dot uk Change the at and dots to make valid email address -- Regards Roger Govier "Wolter" wrote in message ... Hi Roger, I've done nothing so far in VBA because I believed from the help topic mentioned before that this could be done without. Reading your reply it's not possible without VBA. In that case I have missed the point in the help topic. Best regards, Wolter "Roger Govier" <roger@technology4unospamdotcodotuk wrote in message ... Hi Wolter This can only be done using VBA. What code have you written to achieve this? -- Regards Roger Govier "Wolter" wrote in message ... 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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cell locking based on domain user
Hi all,
Problem still persists because Roger was not able to test within a domain and that is crucial for this problem. Locking with passwords seem to work but that is not what I need. Everybody knows how it goes with passwords. Within a few day's it's being shared and, as such, not what I want. -- Best regards, Wolter "Wolter" wrote: Hello Roger, Will do via separate email. Tnx. -- Best regards, Wolter "Roger Govier" wrote: Hi Wolter I apologise. I wrote my response without checking out XL2007 first. As you correctly point out, there is an option to allow the unlocking of locked cells according to different user passwords. I have just created such a list, based upon your example, and it works - as described. Did you remember to Password protect the Worksheet after you had set up the ranges and user passwords? I password protected my sheet, and all worked fine. If you are still having a problem and wish to mail me a copy of your workbook direct, I will take a look To mail direct, send to roger at technology4u dot co dot uk Change the at and dots to make valid email address -- Regards Roger Govier "Wolter" wrote in message ... Hi Roger, I've done nothing so far in VBA because I believed from the help topic mentioned before that this could be done without. Reading your reply it's not possible without VBA. In that case I have missed the point in the help topic. Best regards, Wolter "Roger Govier" <roger@technology4unospamdotcodotuk wrote in message ... Hi Wolter This can only be done using VBA. What code have you written to achieve this? -- Regards Roger Govier "Wolter" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to separate user name and domain name in email id? | Excel Discussion (Misc queries) | |||
| 2007 Converter wont work as domain user | Excel Discussion (Misc queries) | |||
| How to group e-mail adresess based on domain name? | Excel Worksheet Functions | |||
Linear Mode
