| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I report to User A vs User B from shared data table? | Excel Discussion (Misc queries) | |||
| Do anyone know to validating rule for checking the Hong Kong Identity Card no | Excel Programming | |||
| How to: User Form to assign a user defined range to a macro variab | Excel Programming | |||
| User Defined Functions - Help Text - Make it Easy for the User | Excel Programming | |||
| How to: Make user click End User License Agreement acceptance | Excel Programming | |||
Linear Mode
