Thread: Printing Single Page
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default 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?




Reply With QuoteReply With Quote