Paul has already covered most of what I would have said.

Whilst I follow what you describe below, I don't follow it in relation to
what you originally posted at all, no way to slot in stuff about hiding the
form and showing some other within the Initialize event. Is this two
different topics perhaps.

Regards,
Peter T

"Robert Crandal" wrote in message
...
Peter,

Okay, I'll try to explain my situation more....

I actually have 2 userforms. Userform1 is typically
displayed first because it contains buttons and other
controls. There is a button on top of Userform1 which
is designed to show Userform2.

If Userform2 is displayed, I would like to hide
Userform1. Once Userform2 gets closed out, I would
like to re-display the same Userform1 again or bring
it out of its previous hidden state.

I realize that I can leave both Userform1 and Userform2
visible at the same time, but I prefer to keep Userform1
out of view if Userform2 gets triggered. Just wondering
if this is possible.

thanks

Robert

"Peter T" <peter_t@discussions wrote in message
...
Not clear what the real objective is, it'd be better if you explain.

If you merely want to run the form's initialize event without showing it,

Load Userform1 '
' or anything that references the form
' initialize fires

when you want to show it (and run it's Activate event)
Userform1.show

In passing, as looks like you are trying to run the form in the workbook
open event, probably better to run it with an onTime macro, but it
depends.

Regards,
Peter T