see attached workbook
Hi Experts
Need a macro to request log-in (user details) once the user tries to open the workbook.
Here are the conditions:
1. User click to open workbook > User form opens before workbook requesting log-in details
2. Log-in details must match details on Adminsitrator worksheet or Exit
3. cancel button to cancel and exit OK to proceed..
4. If user has no access right msg box " You Are Not Authorised To Accees This WorkBook"
then log-on into workbook See userform alreday designed USer_Log_In
Start Free Trial