UserForm
 

Hello,

I have a UserForm on a worksheet that I want to go away when I click the
Print Preview button, but reappear in the same position that is was before
the PP button was clicked.

Any help?

Thanks,

UserForm
 

Try to hide it using "yourform.hide" before the print preview followed by
"yourform.show" when the print preview has completed.

"Steve" wrote:

Hello,

I have a UserForm on a worksheet that I want to go away when I click the
Print Preview button, but reappear in the same position that is was before
the PP button was clicked.

Any help?

Thanks,