Multi User Login Form - Help

Hello, Need help adding extra steps into code bellow

I have this 7 page workbook, my idea is to hide all pages and have sheet1 ("Login") the default landing page, from here the following needs to happen!
We will have 2 types of users, normal and admin
Normal user, after login sheet3, 4, 5 & 6 or just one of them becomes visible, on each of these pages there is a navigation bar to give them access to rest of the sheets.
Admin user, after login sheet2 becomes visible and from here he/she controls access to all sheets


Idea 1
1- Add multiuser access in code
2- Normal user opens sheet3, say!
3- Admin user opens sheet 2


Idea 2
An alternative to the above would be to:
1- Sheet1 will have 2 command buttons, one to sheet3 and another to sheet2.
2- Only the adim user will have access to sheet2, we need to add password control to this command button! if this is possible?

In this option, Step 2 is where I need help please.

Hope i made this more clear guys
Opening the attached workbook, username = user, password = 1234

Many Thanks

Please Login or Register  to view this content.

Hello tfilipe,

I don't think fellow Forum Members would be willing to create a Workbook trying to guess your setup, and provide you with a ready solution. We are here to help you where you become stuck, and it would be good if you could show us where.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Regards.

Idea1 (not tested)

Not sure exactly what you meant by "Load" Sheet2 or Sheet7.

Please Login or Register  to view this content.

@ AlphaFrog,

Now you have started the guessing game.LOL

Don't you think Admin should have access to both Sheets 2 and 7?

Please Login or Register  to view this content.

Kind regards.

@ Logit,

What are you looking at?

Every question I reply to is riddled with assumptions.

see post 3