miguelc
06-20-2016, 04:10 AM
Hi there!
I am working on a excel sheet (excel 2010) and, being the sheet locked, I want a specific cell to be given edit permissions to specific users depending on the selection of a drop down list (that is unlocked for everyone). For example, you choose the person called 'Marie' from the dropdown list in cell A2 and automatically range B2, which is locked, is given edit permissions to user 'Marie', allowing her to change values.
Thanks in advance.
Regards,
Miguel
I am working on a excel sheet (excel 2010) and, being the sheet locked, I want a specific cell to be given edit permissions to specific users depending on the selection of a drop down list (that is unlocked for everyone). For example, you choose the person called 'Marie' from the dropdown list in cell A2 and automatically range B2, which is locked, is given edit permissions to user 'Marie', allowing her to change values.
Thanks in advance.
Regards,
Miguel