View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
papou[_7_] papou[_7_] is offline
external usenet poster
 
Posts: 41
Default 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 ?