Creating a login page with Excel

Hi, I am trying to write a code to design a login page, in which predefined usernames and passwords are set and used to identify the user logging in into the page.

I have two problems that I would really appreciate if anyone could help me solve them:
1) When excel prompts me to enable macros, if I just click cancel, the excel workbook will open normally and the any user can edit/change and read the remaining sheets in the workbook. How can I make the whole workbook to close if the macro is disabled?

2) I want the username and password entered into the login page to be identified in another worksheet or at least to show up in a cell so I can link other logical functions to it.

I really appreciate your help.

Thanks

Thank you Dave, it is really helpful.
however given that I am still a beginner in programming, I have a couple of questions to ask you regarding the specific code that will show the hidden worksheets!

shoule I write the code as part of the userform? and what type of a function should I use?

Thanks
T

Thanks a lot Dave,

It works now! but moving to the next step, how can I make sure that after the workbook is closed, all the worksheet are again very hidden and that after the new user logs in the same process will be repeated?

Thanks

Thank you so much Dave. You saved my day.

I really appreciate it. my workbook now works perfectly.

Have an awesome evening.

Cheers

thank you roy for the file!

I have another challenge.
The file that I am using is a daily file, that everyday the user copy the file from the day before and change its name to reflect today's date. On the other hand, I have more than one user who will be using the file, while the first one will input some changes, and I want their names to be recorded in one of the worksheets, while the two or three other users will log in after that and just needs to approve the changes done by the first user.
My question:
If I created a list with the corresponding names to each username pre defined, how can I make that name appers in one of the cells in "today's changes" worksheet and after that the second user to sign in, his corresponding name should be registered as authorizer for the changes made by the first user.

I hope this is clear enough for you to help me figure out this!!
Ireally appreciate your help.

Thanks

Dude wats the password for PasswordForm5

unable to open the unhided sheets