Printpreview

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

Thanks

Please Login or Register  to view this content.

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.

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.

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.

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

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

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.

will you be able to rewrite the code?

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