ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Userform.hide / show (https://www.excelbanter.com/excel-programming/277039-re-userform-hide-show.html)

papou[_7_]

Userform.hide / show
 
Neil
You probably have Application.ScreenUpdating set to False
Set it back to True to hide your form
HTH
Regards
Pascal

"Neil" a écrit dans le message de
...
I have an application I am putting together that uses
several forms to represent sections from a hard copy
system. On form1 I have Save, Cancel & For2 buttons.
When I click the button to load form 2, I have against
the button,
Userform1.hide
Userform2.show

This works but it leaves userform1 visable in the
background, I cant get to useform1 which is fine, but it
looks untidy ?

Any ideas ?






All times are GMT +1. The time now is 11:24 PM.

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