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?
|