Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |