user form to log in and access different worksheets of workbook depending on log in name

Hi
New here. Trying to find out how to create a userform to allow different users to access different worksheets of the workbook. I have seen this type of thing on a different forum but cannot get it to link to a userform? Hope im making sense:

username password sheet 1 sheet 2 sheet 3
abloggs 1234 x x
bsmith 5678

x

this somehow links to a user form so the user who enters their username and password only sees the relevant worksheets?

Hi
Firstly you don't need a userform to select a sheet. What I suggest you do is create a Master Sheet at the front of your workbook and create Hyperlinks to each sheet in your workbook.
Then on each of the remaining worksheets right-click on the tab name and select View Code. Then past this code in each sheet:

Private Sub Worksheet_Activate()
a = InputBox("Please Enter Password")
If a <> "password" Then ' Change the here password to suit your needs for each sheet
MsgBox "You entered the wrong Password you will be returned to the main page."
Sheets("Main Page").Select ' Change the title in brackets here to the correct name for your main sheet.
End If
End Sub

Thanks for this - its a neat simple solution but i have about 15 worksheets in my workbook and navigate between them frequently. Its a bit of a pain having to enter a password every time to open a sheet and also one can see a fair bit of the sheet before entering the password so its not exactly what I want but I may use elsewhere - thanks again
Nigel