hi there guys,

i hope somebody can provide me solution for this. I have a workbook which displays userform upon opening. The user then enters his username and password. If username and password is correct, it should only displays the specific worksheet of the user. Currently I have 20 worksheets for 20 users. Let's name the worksheets user01 to user20. I have also another worksheet named "logs" this contains the usernames (in column A) and passwords (in column B). If let's say user05, will open my workbook file, then it will prompt him with a userform asking his username and password. If this match, then it would display the worksheet named "user05" only. The rest of the other worksheets should be hidden and cannot be accessed. anyone knows how can I achieve this? thanks in advance...

regards,

stoey