Userforms

[bopo]

Hi

Basically how do you hide userforms, everytime I tried to hide one using:

unload
.hide


It closes the program which is frustrating, how do I just hide the window without everything closing?

[Charlize]

Unload Meunload the active form from memory
Me.Hidehides the active form
Charlize

[bopo]

Nope, its just closing excel, rather than the window....

also how do I make a specific worksheet display from clicking a userform menu

[lucas]

Hi bopo,
As Charlize shows, unload me will unload the form from memory, me.hide will hide it but its basically still running. Something else in your code is closing Excel if it's closing completely down. Look for something like:

Application.Quit