PDA

View Full Version : Give permission to users to change data in Excel using VBA code [VBA]



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

Kenneth Hobs
06-21-2016, 07:55 AM
That means that anyone could pick Marie and unlock it. You would be better off skipping data validation dropdown and getting Marie and other's computer usernames and unlock it when the file opens. So, do you still want the dropdown method?