PC Review


Reply
Thread Tools Rate Thread

Constantly loaded userform??

 
 
Robert Crandal
Guest
Posts: n/a
 
      6th Dec 2009
When Workbook_Open() is called, I plan to immediately
load one of my userforms. Is it possible to load a
userform as invisible?? Eventually I will make the
userform visible to the user, but if they press the
"X" button I do not want to kill or unload the userform...
I just want to make the userform invisible again if a
user presses "X".

So, in essence, my userform is going to be constantly
loaded as long as the workbook is open...I don't want it
to ever be killed or unloaded, merely just toggled between
visible and invisible.

Is it possible to implement something like this??? Any
code examples?

thank you everyone.


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Check if UserForm is loaded? Peter T Microsoft Excel Programming 4 3rd Sep 2010 06:32 PM
Re: Check if UserForm is loaded? GS Microsoft Excel Programming 3 3rd Sep 2010 02:54 AM
Test if a Userform is loaded or activated?? Robert Crandal Microsoft Excel Programming 6 7th Dec 2009 07:32 PM
Testing if Userform loaded Nigel Microsoft Excel Programming 5 1st May 2007 12:55 PM
Detecting if a userform is loaded Seth Microsoft Excel Programming 2 4th Nov 2003 02:59 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:45 AM.