View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
DSC[_14_] DSC[_14_] is offline
external usenet poster
 
Posts: 1
Default Using different print code

Hi Mark

I don't Know how to remove them but if you only want printing from you
own macro.

You could investigate the Event

Private Sub Workbook_BeforePrint(Cancel As Boolean)

End Sub

If you set the Argument Cancel = True then Excel won't Print.
You could set up a Public Variable such that only when your macro run
when this Event triggers it wont halt your printing.

HTH

Davi

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