Hi Vasant,
Thanks for your help, this is the line of code that I kept
getting wrong but you have solved it for me.

MultiPage1.Pages(1).Enabled = True

(or false as the case may be)

I had all the other logic sorted, just kept getting the
syntax of that line wrong.

Thanks again :)
Phillip

-----Original Message-----
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



.