View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Michael Malinsky[_2_] Michael Malinsky[_2_] is offline
external usenet poster
 
Posts: 32
Default Determining Which Page of MultiPage Initially Shows

But theoretically someone could save, close and reopen the file so that
won't work, will it?

Also, just to muddy the waters (and I should have put this in my first
post)...

Page0 - select option 1, 2, or 3 (selected option will next show Page1,
Page2, or Page3)
Page1 - do stuff then show Page4
Page2 - do stuff then show Page4
Page3 - do stuff then show Page4
Page4 - do stuff then Finish

So the first time the code is run, it will start on Page0 and end on
Page4 with Page1, Page2, or Page3 in the middle depending on the option
button selected in Page0. So hiding the UserForm still won't provide
the desired result. So if I choose option 2 the first time the code is
run, I want to start with Page2 if the code is run again.

Is that clearer?

Thanks,
Mike.