UserForm

S

Steve

Yesteday, I wrote this question:
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.
Click to expand...

The answer that I received was:

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

How will I know when the user click the close button from the print preview
of the workbook? I can't seem to find how I would know that.

THanks,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I set focus (and select text) on a text box on a modeless userform? 0
Userform to Select what worksheets to print 1
WHERE ARE MY BUTTONS 0
UserForm 1
HPageBreak not working 4
Need Help with Print Out of Userform 1
Appearance of Controls misbehaving 1
Click on userform transfers to lisbox below 1

Top