Print preview from user form opened from a user form

Hello everyone

I have a problem with Excel locking up when calling PrintPreview from a UserForm. The solution to this problem seems to be something along these lines:

Me.Hide
Sh.PrintPreview
Me.Show

The problem is that I have two userforms open when calling PrintPreview. I tried doing this:

Me.Hide
OtherForm.Hide
Sh.PrintPreview
OtherForm.Show
Me.Show

Doing this only OtherForm is displayed. When I close OtherForm Me is showed again.

There is another problem as well. It appears that calling Hide and then Show calls the Activate event which does a bunch of initializations that I don't want. All I really want is to HIDE them, i.e. I want the values of all the controls to be the same and for no events to be triggered.

Solution?

Thanks in advance