Input Box Prompt for password

Not sure if I follow you correctly, but this might help

thank,for your help and your good example.
but i have more problem..for you help.
1.when input the correct username and password ,why..? it showed msg."sorry,you must enter password "
can change code for not to show this msg. when input the correct uersname and password..
2.you set the user="Manager" and password ="secret " can you change the code for username more than 1 person using the excel file such as 10 person ex. . "Mr.a ,Mr.b ,Mr.c ,....... and the password ...password1,password2,password3.......in your code
3.can you modify for the user to change the username and password by themself ??
4.can you hide all menu of excel sheet must not show after the user key correct username and password

I have re-written the code and included an examle of using multiple users with different passwords - see the Multi User Button.

Thans So Much ,Roy Uk
May Be I Have The Wrong Queution ,I Have The Ex .For You Help Me Again
1.I Have The Excel File , I Want To Set About 15 Users
With Usersname And Password In The Table Of"Sheet Username And Password Control The First Use In Part 1 . All Users Can Change The Passsword" By Themself . The New Password Will Replace In The Old Password -Look As Ex.File Sheet "Username And Password Control"

1.2 When The User Click The File . It Popup Login In Sheet "Main "
If The Correct Username And Password . The Sheet "Main "Is Hidden And The Sheet Menu Is Show And The Menu Bar In The Sheet Menu Is Hide If The Uncorrect Password And Username Will Have The Msg .Box "Un Correct Password Or Username "
If The Uncorrect Password Or Username More Than 3 Times The File Will Be Closed And Exit With The Msg.Box " 3 Times Uncorrect Password And Uersmane ,The File Will Closed And Exit Now"

1.3 The User Can Change The New Password .If Click "Ok" The Sheet Main Is Hidden .The Msg.Box "Change The Password And Replace In Old Password Is Accepted "
And The Sheet Munu Is Show With The Munu Bar Is Hidden

i have given you twod code examples which can be adapted if you study them.

I have given you example code that you can adapt. You haven't even tried!