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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200511/1

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" <u13950@uwe wrote in message
news:576ac5ed1d73b@uwe...
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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200511/1

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

Chip Pearson wrote:
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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200511/1