Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enable Property of Multipage Control Pages = CheckBox.Value
How can I enable all Pages of a Multipage Control it a checkbox = True, and
disable pages it the checkbox = False? Sub EnablePages () Dim myPages as Collection Dim ctrl as Control 'all pages in multipage paint section Set myPages = New Collection With myPages .Add pgColor1 .Add pgColor2 .Add pgColor3 .Add pgColor4 .Add pgColor5 .Add pgColor6 End With For Each ctrl In myPages ctrl.Enabled = chkPaint.Value Next ctrl End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error saying Control object does not have Enable property. | Excel Programming | |||
Loop through pages in multipage control | Excel Programming | |||
how to switch pages in a multipage control by a commandbutton | Excel Programming | |||
Multipage Control Pages - Changing Index Value in Code | Excel Programming | |||
Multipage Control Pages - Changing Index Value in Code | Excel Programming |