MultiPage Form

Hello there,

Is it possible to have a MultiPage User form and make one of the pages accessible only by password?

Besides that, how I actually assign the code for the different pages. I tried to combine two user forms in one Multipage but could not figure it out how add the two sets of codes.

Thanks!

Hi, You could try something like this:-
Place this code in the Userform Module:-

When the userform Shows, Page(1) is shown, If you try to access Page (2) the "Input Box" shows asking for a password.
If there is no password or the wrong Paswword then Page (2) will not open.
The Password here is "MyPword"

Please Login or Register  to view this content.

Regards Mick

Well this code is asking for a password,but Page2 is visible and I can open it even password is not entered.

Besides that, can you please explain, when I have 2 pages and 2 different user forms on them, how do I specify which part of the code is for User Form1 and which is for User Form2.

All the code goes in one place, so how I do it?

Hi, I think its because I've given you a bit of code thats not required.
Change the code below to remove the ref to the userform Name. As long as the code is in the correct Userform module you don't need it.
You only need one Userform with a Multipage with two pages.
When the code runs the Initialization code set the Userform to show the first page.
Then the other code clicks in when you select the second page.
NB:- You need to insert this code by having the userform in design mode, and then double clicking the userform to show its code module.
Change This:-

Please Login or Register  to view this content.

to this:-

Please Login or Register  to view this content.

Regards Mick