userform and printpreview

[Pierre via OfficeKB.com]

Hi,

My application runs entirely through a userform.
However, the user want to print out some stuff so i have a button called
print which hides
hides the userform, shows Excel again and shows a printpreview of a sheet
(protected) .Printing or closing that screen will take the user back to the
userform and make Excel invisible again.

I would like to have the printpreview in the (multipage)userform.
Is this possible and if so, how do i go about it ?

Thanks,
Pierre

 

[Chip Pearson]

Do you mean that you want the actual preview image to appear on a
userform? Not possible.


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

 

[Pierre via OfficeKB.com]

Hi Chip,
Yes, that is what i meant...
Thanks anyway.
Pierre

Do you mean that you want the actual preview image to appear on a
userform? Not possible.

Hi,

[quoted text clipped - 14 lines]

Thanks,
Pierre