View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Change properties of a multipage

And you can use the name of the page if you want:

Me.MultiPage1.Pages("pg4").Visible = False



Gerhard Ganser wrote:

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 ***


--

Dave Peterson