Printpreview

[RJ1969]

Hi,
Can you please make this code to be Sheet2 instead of the activewindow.

Thanks

Please Login or Register  to view this content.

[RJ1969]

Hi,
I want the printpreview for Sheet2 instead the activewindow.
If the code can printpreview Sheet2 and close then after as a macro.

Thanks.

Please Login or Register  to view this content.

[RJ1969]

Hello,
This is what I came out with a code and it works for me but I need to add a code "close print preview".

Please Login or Register  to view this content.

[RJ1969]

Let me clarify, maybe it will help the issue.

I want the print preview in Sheet2 to wait for a 2 seconds then it will manually closed the print preview.

Please if you can write some code to be added on this:

End With
With Worksheets("Sheet2").PrintPreview
End With
End Sub

Thank you.

[RJ1969]

Oooops... I meant automatically closed the "Print Preview"

[scottiex]

Print preview suspends the code. So this is at least not a simple request, you may get no answer.

Why do you want to do this anyway?
You seem to be asking to show the print preview then immediately hide it?

[RJ1969]

Yes, i need the print preview to show then after a seconds will immediatelt hide it or close the print preview

[RJ1969]

This is what I have so far but Its not working.
There is a 2 seconds but it does not automatically kill the preview.

Please Login or Register  to view this content.

[scottiex]

Yes, that is what I was saying,

I think you will find With Worksheets("Sheet2").PrintPreview stops your code.
As a result you never get to the next line where you are trying to send keys "escape". Not easy to get around.

[RJ1969]

will you be able to rewrite the code?

[scottiex]

unless someone else has an idea -

Maybe take a step back and think why you need this to happen.

Maybe you just need to see the page layout or the page break preview or something like that?

[RJ1969]

Ok.
What about print preview and close print preview sub macro vba code? This will probably work for me.