Please help! Userform to allow access or assign different users with Different Sheets in workBook.

[pedie]

Thanks for helping in Advance

I have some idea on how to design the userform, i need help with the code.
If user1 enter the username and password correctly I want only the "sheet1" & "sheet2" to visible.
is user2 enter the username and password correctly I want only the "sheet3" & "sheet5" to visible.
And If possible I want the code to restrict user1 from accessing user2 page(that is Sheet3 and sheet5)
If worng information entered then
activework.close
closing the sheet hides all the sheet except sheet4 which is visible all the time...

Dim username, password As String
username = TextBox1.Text
password = TextBox2.Text
.....
Thanks for helping in Advance.
Pedie!

 

[pedie]

I'm still waiting.....

 

[Smitty]

If you PM me your e-mail address I'll send you a workbook that allows you to set which sheets users can access.

 

[pedie]

Thanks for your offer to help....Pedie
I have PM u!