USER/LOGIN to different sheets

Hey everyone

I havent been on here for a while but I hope someone can help me.

I am using the following code on a userform to force the users to 'log in' to view the sheets. I used a Auto Open macro to bring up the form when the file is opened.

Please Login or Register  to view this content.

This all works fine.....HOWEVER....

I need to make it so that if a user logs in using the name 'Simon' they would only see the 'Simon' sheet. And the same for all of the other users.

Any ideas on how I can mod this code to do that for me??

Any help is much appreciated

Simon

sorry roy but im not the most skilled with excel so im gna need abit more prompting than that...if possible?

excellent Roy

All i had to do was take the (Me.usernametextbox.Text) and put it was the sheet to be displayed when the user entered the correct info and clicked Login.

Works perfectly

Thankyou