Something like:

Private Sub UserForm_Initialize()
If Range("A1") = "X" Then
MultiPage1.Pages(1).Enabled = True
Else
MultiPage1.Pages(1).Enabled = False
End If
End Sub

--

Vasant



"Phillip Topping" wrote in message
...
I have a user form with a multipage on it.

Most of the time all the pages are enabled but there will
be some occasions that when the form loads, I will need to
disable all but one of the pages. I know I can disable
them just by changing their enabled/disabled status in the
form design but this does not help me.

I need to be able to change their status dependent on the
results of cell contents using If..Then etc.

I cannot find any way in VB to help me do this.

Any suggestions would be greatly appreciated.
TIA
Phillip