U_Shrestha
03-07-2008, 10:27 AM
Hello,
I have attached a sample workbook. Basically, I would like to assign several log in names in the workbook. A user will select their log in names, enter password and then be able to view their list of data. Right now all these log in names are assigned to a button but I want to have a list of user names in a list box or something where a user can choose their user name, and as soon as they select their user name they should be prompted to enter their password and once they have entered their password they would be able to look at their filtered data.
In my current workbook, the password appear as text, I want to change it as asterisk, in that case do I need to make a separate form for each user or their is a shortcut to do it? I would appreciate you help. Thanks.
I have attached a sample workbook. Basically, I would like to assign several log in names in the workbook. A user will select their log in names, enter password and then be able to view their list of data. Right now all these log in names are assigned to a button but I want to have a list of user names in a list box or something where a user can choose their user name, and as soon as they select their user name they should be prompted to enter their password and once they have entered their password they would be able to look at their filtered data.
In my current workbook, the password appear as text, I want to change it as asterisk, in that case do I need to make a separate form for each user or their is a shortcut to do it? I would appreciate you help. Thanks.