View Full Version : Userforms
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
01-17-2007, 07:30 AM
Unload Meunload the active form from memory
Me.Hidehides the active form
Charlize
Nope, its just closing excel, rather than the window....
also how do I make a specific worksheet display from clicking a userform menu
lucas
01-17-2007, 08:45 AM
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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.