ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Multipage Part of Form (https://www.excelbanter.com/excel-programming/365941-multipage-part-form.html)

Bill[_30_]

Multipage Part of Form
 
Hello All,
Is it possible to set enabled = false for one page in a multipage form? If
so, how? Thanks.

Bill



FourBlades

Multipage Part of Form
 
No, but you can probably set the visible property of the object ON that page
to FALSE if you don't want the user to see it at certain times.

"Bill" wrote:

Hello All,
Is it possible to set enabled = false for one page in a multipage form? If
so, how? Thanks.

Bill




Harald Staff

Multipage Part of Form
 
Hi Bill

This disables its tab -you can't select it and go the

MultiPage1.Pages(1).Enabled = False

If you want to go there but ensure everything there is disabled then an old
trick is to place the controls inside a Frame and disable the frame, like

Frame1.Enabled = False

(Note that controls themselves do not "grey out" when it's their container
that's disabled.)

HTH. Best wishes Harald


"Bill" skrev i melding
k.net...
Hello All,
Is it possible to set enabled = false for one page in a multipage form?

If
so, how? Thanks.

Bill





FourBlades

Multipage Part of Form
 
Oops, I stand corrected.

"Harald Staff" wrote:

Hi Bill

This disables its tab -you can't select it and go the

MultiPage1.Pages(1).Enabled = False

If you want to go there but ensure everything there is disabled then an old
trick is to place the controls inside a Frame and disable the frame, like

Frame1.Enabled = False

(Note that controls themselves do not "grey out" when it's their container
that's disabled.)

HTH. Best wishes Harald


"Bill" skrev i melding
k.net...
Hello All,
Is it possible to set enabled = false for one page in a multipage form?

If
so, how? Thanks.

Bill







All times are GMT +1. The time now is 01:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com