View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default ActiveSheet.Printout

Hi AA2e72E,

My reply was reasonably succinct and, I thought, not open to
misinterpretation.

You have succeeded in so doing. Congratulations!


---
Regards,
Norman

"AA2e72E" wrote in message
...
I am aware of the DisplayAlerts switch; it does NOT work.

"Norman Jones" wrote:

Hi Don,

I do not think that this works and I am not aware of a method for
suppressing this message.

---
Regards,
Norman


"Don Guillett" wrote in message
...
application.displayalerts=false
your code
application.displayalerts=true

--
Don Guillett
SalesAid Software

"AA2e72E" wrote in message
...
Can the dialogue that appears after ActiveSheet.Printout be

suppressed
i.e. prevented from appearing?