ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Hide form page (https://www.excelbanter.com/excel-programming/437117-hide-form-page.html)

Paul

Hide form page
 
I have a form with a multipage control.

I want to hide or show the relevant pages dependant on user selections.

How can I hide a page with VBA ?


Ryan H

Hide form page
 
For a multiphage control you can use this.

MultiPageName.Pages(0).Visible = False

I'm not sure what pages you want to hide, but you can modify this a little
to suit your macro. Just change the 0 to which ever page you want hidden.

Hope this helps! If so, click "YES" below.

--
Cheers,
Ryan


"Paul" wrote:

I have a form with a multipage control.

I want to hide or show the relevant pages dependant on user selections.

How can I hide a page with VBA ?



All times are GMT +1. The time now is 11:16 AM.

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