Is it possible to disable a tab/page on a multipage Userform?
 

I know you can set this in the properties to Enabled = True/False, but can
you set this in a macro somthing like:

Userform.Page1.Enabled = False


--
Trefor

Is it possible to disable a tab/page on a multipage Userform?
 

Me.MultiPageName.Pages(index).enabled = false

Me = the form active where multipage is present
MulitipageName = named multipage
Index = place of the page to enabl

--
Zur
-----------------------------------------------------------------------
Zurn's Profile: http://www.excelforum.com/member.php...fo&userid=1464
View this thread: http://www.excelforum.com/showthread.php?threadid=53405

Is it possible to disable a tab/page on a multipage Userform?
 

Me.MultiPage1.Pages(1).Enabled = False

which is Page2 as Index starts at 0

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Trefor" wrote in message
...

I know you can set this in the properties to Enabled = True/False, but can
you set this in a macro somthing like:

Userform.Page1.Enabled = False


--
Trefor

Is it possible to disable a tab/page on a multipage Userform?
 

Zurn,

Perfect thankyou
--
Trefor


"Zurn" wrote:


Me.MultiPageName.Pages(index).enabled = false

Me = the form active where multipage is present
MulitipageName = named multipage
Index = place of the page to enable


--
Zurn
------------------------------------------------------------------------
Zurn's Profile: http://www.excelforum.com/member.php...o&userid=14645
View this thread: http://www.excelforum.com/showthread...hreadid=534056

Is it possible to disable a tab/page on a multipage Userform?
 

Bob,

Perfect thankyou
--
Trefor


"Bob Phillips" wrote:

Me.MultiPage1.Pages(1).Enabled = False

which is Page2 as Index starts at 0

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Trefor" wrote in message
...

I know you can set this in the properties to Enabled = True/False, but can
you set this in a macro somthing like:

Userform.Page1.Enabled = False


--
Trefor