Jedidia
asked on
EXCEL VBA
Is there a way to code a VBA script to detect a users login ID (userID = LCase(Environ$("username") )) and based on the result lock the active cell from being edited?
Basically if user A, B, & C clicks in a specific cell and makes changes no problem.
If user D or E tries, it prevents the edit and displays a little "You don't have access" message?
Can this be done strickly with VBA code? If so, can you help with examples.
Thanks -
Basically if user A, B, & C clicks in a specific cell and makes changes no problem.
If user D or E tries, it prevents the edit and displays a little "You don't have access" message?
Can this be done strickly with VBA code? If so, can you help with examples.
Thanks -
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Open in new window