Thread: Print Macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
The Rook[_2_] The Rook[_2_] is offline
external usenet poster
 
Posts: 70
Default Print Macro

I currently the following macro set up to print the active workbook. What do
I need to ad to this to exclude sheet 1?:

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 21/03/2007 by me'

'
ActiveWorkbook.PrintOut Copies:=1, Collate:=True
End Sub