Click the form to toggle visibility of page-4
Private Sub UserForm_Click()
With Me.MultiPage1.Pages(3)
.Visible = Not .Visible
End With
End Sub
Multipage pages are indexed from zero, so MultiPage1.Pages(3) refers to the
4th page
Regards,
Peter T
"Gerhard Ganser" wrote in message
...
I am working with Excel 2007
I have a form (frmMenu) with a multipage (Multipage1)containing 4 pages
(pg1, pg2, pg3, pg4).
I would like to change the visible property of page 4 (pg4) from true to
false using VBA code. I don't seem to be able to find the code needed
to select pg4 to change the properties of this page.
Can you help?
*** Sent via Developersdex http://www.developersdex.com ***