Print Preview and Modeless Form
 

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

--
tmor
-----------------------------------------------------------------------
tmort's Profile: http://www.excelforum.com/member.php...fo&userid=2105
View this thread: http://www.excelforum.com/showthread.php?threadid=38939

Print Preview and Modeless Form
 

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

Me.Hide: DoEvents
ActiveSheet.PrintPreview
Me.Show

MP

"tmort" a écrit dans le
message de news: ...

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

After all of the data is entered I'd like to be able to call a print
preview of the report on one of the worksheets. I can set a command
button to do a print previes of the worksheet but it appears below the
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 do
the print preview but it doesn't record minimizing the form.


Any ideas?

Thanks


--
tmort
------------------------------------------------------------------------
tmort's Profile:
http://www.excelforum.com/member.php...o&userid=21053
View this thread: http://www.excelforum.com/showthread...hreadid=389390