User identity

[Guest]

Hi.....As it is possble to grant access to protected cells without use of
password to specified users, Excel in some way “logs†the identity of the
user.
We would like to “grab†the identity of the user and via a macro stamp this
identity into a specified cell.

Is anyone having a brilliant idea?

 

[Guest]

Hi Tine

You can get user ID easily enough Environ$("Username") will return this. You
could check this value in a start up macro and unprotect the cells if the
user is found, or protect the cells if not found. Ideally you want to
intercept any save request and ensure that the cells are protected at the
time of saving