Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Default multi page
Set the Multipage value first before opening form Mymain.MultiPage1.Value = 0 'Where zero is page1, 1 is Page 2 etc Mymain.Show -- Regards, OssieMac "Bill" wrote: Have read the other Q&A's on default multipage and still cant get it to work Want to open on page 0, on open, here is code Workbook opens and immediatly displays user form Private Sub workbook_open() MsgBox "Agree to confidentiality message" Mymain.Show 'need to default to page 0 the first page 'mymain is name of user form Mymain.MultiPage1.Value = 0 Mymain.MultiPage1.Pages(1).Visible = True End Sub Thanks in advance from australia |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I e-mail 1 page of a multi page workbook | Excel Discussion (Misc queries) | |||
Multi-Page Objects Activate Page | Excel Programming | |||
Multi Page Scroll Bar | Excel Programming | |||
Get header only on first page of multi page excel file | Excel Discussion (Misc queries) | |||
Hide a page in a multi page userform | Excel Programming |