UserForm

S

Steve

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,
 
L

Lasborough

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

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

Optionbutton Not working 3
I figured out the issue thank you. 0
How do I set focus (and select text) on a text box on a modeless userform? 0
Generated text copies into another template 0
Userform to Select what worksheets to print 1
UserForm 0
Cannot Change Back to Previous Settings After Clicking "Try the new Outlook" 0
Click on userform transfers to lisbox below 1

Top