Ciao max_max,
In the attached workbook, the UserForm has been modified for the password. The UserForm is modal, the close X has been removed, closing the Userform using ALT+F4 is disabled, and the user's login Id is used to lookup the password on a new sheet "Elenco".
This sheet holds the allowed user ids and their passwords. If the password and user id do not match then the workbook closes. You should set this sheet's Visible property to xlSheetVeryHidden. This prevents the user from making the worksheet visible. This property can only be changed using the VB Editor. You can change it to xlSheetVisible when you need to edit the list.
The workbook closing feature has been disabled to allow you to setup the user ids and passwords. Once you have done this, you will need to edit the OK button code on the UserForm. Remove the comment character from the beginning of the line marked in bold and save the change.
Bookmarks