User identity
 

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?

User identity
 

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


--
Tony Green


"Tine" wrote:

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?