[SOLVED] 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

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

[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" <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

[Pierre via OfficeKB.com]

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