| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| activate a page of a Multipage in Userform | Excel Discussion (Misc queries) | |||
| can you set a default page in a Multipage userform? | Excel Programming | |||
| How to print a page of a multipage userform | Excel Programming | |||
| Looking for eloquent solution: Determine of any control on a page of multipage has been altered (userform) | Excel Programming | |||
| Enable/disable page on multipage | Excel Programming | |||
Linear Mode
