View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert Crandal Robert Crandal is offline
external usenet poster
 
Posts: 309
Default Constantly loaded userform??

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.