Userforms and Print Preview
 

I'm using multiple page userforms. On one of the pages I have a comman
button to Print Preview one of the worksheets. My goal is to allow th
person to preview the answers after they have entered all th
information on the userforms.

The problem is when I Print Preview a page the print preview page stay
behind the userform and Excel doesn't allow me to get control of th
print preview window. I've tried open the user form with th
vbModeless option but it still does not work.

Is it possible to be in a userform and print preview a worksheet? I
so, how would I do it?

Thanks for any help

--
Message posted from http://www.ExcelForum.com

Userforms and Print Preview
 

Steven,

You need to hide the form prior to calling the print preview,
then show the form after. For example,

TheForm.Hide
ActiveSheet.PrintOut Preview:=True
TheForm.Show


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Steven Ducotey "
wrote in message
...
I'm using multiple page userforms. On one of the pages I have
a command
button to Print Preview one of the worksheets. My goal is to
allow the
person to preview the answers after they have entered all the
information on the userforms.

The problem is when I Print Preview a page the print preview
page stays
behind the userform and Excel doesn't allow me to get control
of the
print preview window. I've tried open the user form with the
vbModeless option but it still does not work.

Is it possible to be in a userform and print preview a
worksheet? If
so, how would I do it?

Thanks for any help!


---
Message posted from http://www.ExcelForum.com/

Userforms and Print Preview
 

Thank you very much!


---
Message posted from http://www.ExcelForum.com/