ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Printing Single Page (https://www.excelbanter.com/excel-programming/338946-printing-single-page.html)

Paul Smith[_3_]

Printing Single Page
 
Application.DisplayAlerts = False
Worksheets("FinancialStatement").PrintOut To:=1
Application.DisplayAlerts = True

When I run the above code I see the notification box that I am print pages 1
of 6, how do I stop this message being seen by the users?



Tom Ogilvy

Printing Single Page
 
http://tinyurl.com/8f3dj

A solution suggested by Stratos Malasiotis

--
Regards,
Tom Ogilvy

"Paul Smith" wrote in message
...
Application.DisplayAlerts = False
Worksheets("FinancialStatement").PrintOut To:=1
Application.DisplayAlerts = True

When I run the above code I see the notification box that I am print pages

1
of 6, how do I stop this message being seen by the users?






All times are GMT +1. The time now is 11:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com