Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to disable and enable multipage elements during runtime?
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to disable and enable multipage elements during runtime?
Try it this way...
With MultiPage1 For X = 1 To .Pages.Count MultiPage1.Pages(X).Enabled = True Next End With You can address individual pages via its Index in the Pages collection. Rick "Yajiv" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to disable and enable multipage elements during runtime?
Whoops! Dave is right... the Indexes for MultiPage are zero-based, so my
code should have been... With MultiPage1 For X = 0 To .Pages.Count - 1 MultiPage1.Pages(X).Enabled = True Next End With Rick "Rick Rothstein (MVP - VB)" wrote in message ... Try it this way... With MultiPage1 For X = 1 To .Pages.Count MultiPage1.Pages(X).Enabled = True Next End With You can address individual pages via its Index in the Pages collection. Rick "Yajiv" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enable/Disable Macro | Excel Programming | |||
MultiPage: How to enable controls in Frame on Page | Excel Programming | |||
Is it possible to disable a tab/page on a multipage Userform? | Excel Programming | |||
Enable/Disable Macro | Excel Programming | |||
Enable/disable page on multipage | Excel Programming |