Thread: Deactivating Printing Message
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default Deactivating Printing Message
here is a sniplet that i saved. i haven't used it yet but
you can try it.
sniplet to turn of alerts such as save a file before close.
Application.DisplayAlerts = False
Worksheets("Report").Delete
Application.DisplayAlerts = True

-----Original Message-----
When printing a document via a macro can the printing
message which
appears on screen be turned off.

I am using the following command

ActiveWindow.SelectedSheets.PrintOut Copies:=1,
Collate:=True

Tony


---
Message posted from http://www.ExcelForum.com/

.

Reply With QuoteReply With Quote