Userform Login for Multiple Level User

Question

Hello,

I have a shared workbook which uses by multiple users, i ask to set a user form login have a different authorization level.

this workbook have 6 spreadsheets.

1st sheet: is the interface contain login image that when hit it the Userform Login popup  

2nd sheet: called SLA Calendarthis worksheet will available for all the users

3ed sheet: called SysUsethis will available for Admins only

and the other sheet concern the creator

I have 3 levels criteria for users to deal with the workbook: i have been inserted the users, admins and creator and them passcodes in sheet called Login

authorization levels: want to worksheet opened permanently in Interface worksheet to login  

Users permission: want to workbook ribbons and formula bar will be auto-hidden and when he insert the valid username and password will move to SLA Calendarsheet and the other sheets will be very hidden

Admins Permission: the same permission for Users but let SysUse sheet to be shown the other sheets will be very hidden

Creator Permission: all workbook sheets will be available. 

I hope if can i obtain the Admins activities in SysUse sheet with times and dates, there is a empty table for users and time in Login sheet for this activities as when any Admin make any modification in the sheet his user and action time will be available in this table

the attached sheet

Gratefully,

Answer 1

Hello AhmedAbdel,

Welcome to Microsoft community and thank you for posting your query.

Since the issue is with user form in Excel, you may post your query in Excel IT pro using the forum link below.

http://social.technet.microsoft.com/Forums/en/excel/threads

Thank you.