when i am opening an application i have two sheets , for that based on qvuser() i need to lock and unlock fields.
if the Qvuser() is in the list of an excel file then it should show all the values of a field called NAME without any LOCK.
but if the user is not there in the list but is there in a field called MEMBER then it should lock that MEMBER name so that he cannot select other MEMBERS.
i tried with Triggers.but i am not able to achieve the condition. is there an way to do the same.
