Thread: How to disable and enable multipage elements during runtime?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default How to disable and enable multipage elements during runtime?

Dim mCtr As Long
For mCtr = 0 To Me.MultiPage1.Pages.Count - 1
Me.MultiPage1.Pages(mCtr).Enabled = True
Next mCtr

To toggle the .enabled property:

With Me.MultiPage1.Pages(mCtr)
.Enabled = Not .Enabled
End With

Yajiv wrote:

I have a multipage with four pages. I want to enable them when some
condition is satisfied. How can i do that? The intelli-sense is not
displaying my page names.

--

Dave Peterson
Reply With QuoteReply With Quote