Print Preview and Modeless Form

[tmort]

I have a modeless form that I'm using for data entry. The form is o
top and the worksheets on the bottom.

After all of the data is entered I'd like to be able to call a prin
preview of the report on one of the worksheets. I can set a comman
button to do a print previes of the worksheet but it appears below th
form and it seems to disable the minimize button on the form.

I thought I could just record a macro to minimize the form and then d
the print preview but it doesn't record minimizing the form.


Any ideas?

Thank

 

[Michel Pierron]

Hi tmort,
You must hide your form before to do a print previes :

Me.Hide: DoEvents
ActiveSheet.PrintPreview
Me.Show

MP