How to put a password in between pages

Hello friends,


I want to make a macro in i can put a password one the page 1 and after that is the password is correct only then the user can access on the next page.

Can do by this code:

If InputBox(prompt:="Enter Password", title:="Enter Password", Default:=0) = "Whatever" Then

If you want to stick with macros, you can see if the input box is available there.

Can do by this code:

If InputBox(prompt:="Enter Password", title:="Enter Password", Default:=0) = "Whatever" Then

If you want to stick with macros, you can see if the input box is available there.

In VBA you can do this by::

Code:

If InputBox(prompt:="Enter Password", title:="Enter Password", Default:=0) = "password" Then
'Open that form
Else
'Open the other form
End If