UserForm That Brings Specific Worksheet Up, Hides All Else

[KittenSwagger]

Hello,

Im trying to make something that will bring up one specific worksheet when a username and password is entered, and only that sheet. I am running into problems where It opens the last saved worksheet can be seen in the background until you enter the username/password. Additionally, it will only show the correct worksheet after you click on the tabs, then runs a "You cant do that" message for every other tab.

I want to make this as simple as a I can so that it simply bring us ONE worksheet automatically when they enter their username/password. can anyone help me out?

This is the code in the Workbook:

Please Login or Register  to view this content.

This is the code in the User Form:

Please Login or Register  to view this content.

[Norie]

Any chance you could upload a sample workbook?

Click on GO ADVANCED, scroll down and click Manage Attachments.