bweiss5421
New Member
- Joined
- Aug 17, 2016
- Messages
- 1
I need some help in creating a protection method that would block all unauthorized users (via LDAP username lookup) from opening a workbook.
If they are not an authorized user, the workbook will close, displaying a message "Account <account name> is not authorized to open this workbook" and upon clicking an Ok button, the workbook should close.
If they are an authorized user, the workbook will open, displaying a message "Account <account name> successfully opened the file".
I have done some "googleing" on this topic, but nothing has really been exactly what I need.
I know I will need to lookup the currently logged in user, verify it against some list or group, and then take the appropriate action based on the result of this verification.
Any help or insight as to how I might achieve this would be much appreciated!
If they are not an authorized user, the workbook will close, displaying a message "Account <account name> is not authorized to open this workbook" and upon clicking an Ok button, the workbook should close.
If they are an authorized user, the workbook will open, displaying a message "Account <account name> successfully opened the file".
I have done some "googleing" on this topic, but nothing has really been exactly what I need.
I know I will need to lookup the currently logged in user, verify it against some list or group, and then take the appropriate action based on the result of this verification.
Any help or insight as to how I might achieve this would be much appreciated!
