MultiPage

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
On 2002-03-11 13:45, waggy30 wrote:
Hello
Does anyone know how I would disable a page in a multipage?

You can hide a page if you like:

MultiPage1.Pages(1).Visible = False

Would hide the second page (multipage pages are zero-based).

Hope this helps,

Russell
 
Upvote 0
Sorry didn't explain myself properly. What i want is to refer to the enabled property of a page in a multipage. I've tried

multipage1.page1.enabled = False

but it doesn't work. Any ideas?
 
Upvote 0
Russel i used your code, and used it in mine

Private Sub UserForm_Initialize()
If Range("route") = "1" Then
MultiPage1.Pages(0).Visible = False
Else
MultiPage1.Pages(1).Visible = False
End If
End Sub

And i get run-time errors. Any idea why?
 
Upvote 0
On 2002-03-11 14:26, waggy30 wrote:
Russel i used your code, and used it in mine

Private Sub UserForm_Initialize()
If Range("route") = "1" Then
MultiPage1.Pages(0).Visible = False
Else
MultiPage1.Pages(1).Visible = False
End If
End Sub

And i get run-time errors. Any idea why?

It could be in your "Range" reference. You need to precede it with the sheet. For example,

Sheets("Sheet1").Range("route")

Hope this helps,

Russell
This message was edited by Russell Hauf on 2002-03-11 17:43
 
Upvote 0
On 2002-03-11 14:26, waggy30 wrote:
Russel i used your code, and used it in mine

Private Sub UserForm_Initialize()
If Range("route") = "1" Then
MultiPage1.Pages(0).Visible = False
Else
MultiPage1.Pages(1).Visible = False
End If
End Sub

And i get run-time errors. Any idea why?

What is the exact error and where is it happening (hit debug when you get the error to find out)?
 
Upvote 0

Forum statistics

Threads
1,213,490
Messages
6,113,957
Members
448,535
Latest member
alrossman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top