Hey,

I have a workbook which has a userform with a username and password scenerio. There are access levels to determine what the user can do on the sheet.
when a certain access user logs in it unprotects a sheet.
Does anyone know a code to protect the sheet on exit? Obviously if I dont have this code, user 1 with full access will come and unlock it and make changes then when he logs off user 2 can log on and access everything even though he supposed to have no access.

Thanks in Advance

Dave