Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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 ?




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Userform won't show when file re-opened Gerry O Excel Discussion (Misc queries) 2 September 4th 07 05:42 PM
Properties window show nothing for a userform Cheer-Phil-ly Excel Discussion (Misc queries) 0 July 27th 06 07:15 PM
Hide/Show modeless userform when activating/deactivating workbooks Jeremy Gollehon[_2_] Excel Programming 0 August 28th 03 11:05 PM
hide a textbox on a userform? Bill Lunney Excel Programming 2 July 31st 03 08:57 AM
show a userform Joe[_17_] Excel Programming 0 July 18th 03 03:25 PM


All times are GMT +1. The time now is 01:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"