Nandakumar
Member
Dear All,
I am having a sheet which contains data in each row and there is a dropdown of names.
Once particular person fills the data in particlar row,it should be locked and password controlled by admin.
Ex
Row A - Data from A2 to E2,F2-person name and again data from G2-W2.
Once Particular person enters the data in A2 to W2,it should be locked (we can have dropdown as Lock/unlock in X2) to lock with password
Like that in all the rows A3,A4,A5.....
Request a macro for the same.
Thanks in advance.
Regards
I am having a sheet which contains data in each row and there is a dropdown of names.
Once particular person fills the data in particlar row,it should be locked and password controlled by admin.
Ex
Row A - Data from A2 to E2,F2-person name and again data from G2-W2.
Once Particular person enters the data in A2 to W2,it should be locked (we can have dropdown as Lock/unlock in X2) to lock with password
Like that in all the rows A3,A4,A5.....
Request a macro for the same.
Thanks in advance.
Regards