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 Calendar this worksheet will available for all the users
3ed sheet: called SysUse this 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 Calendar sheet 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
Gratefully,
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 Calendar this worksheet will available for all the users
3ed sheet: called SysUse this 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 Calendar sheet 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
Gratefully,