Guest User

Untitled

a guest
Apr 26th, 2018
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.40 KB | None | 0 0
  1. Sub PRINTPDF_()
  2. '
  3. ' PRINT_ Macro
  4. ActiveWorkbook.Sheets.Select
  5.  
  6.  
  7. ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
  8. "Monthly Progress Report.pdf", Quality:=xlQualityStandard,
  9. IncludeDocProperties:=True, _
  10. IgnorePrintAreas:=False, OpenAfterPublish:=True
  11. 'Application.PrintCommunication = True
  12. 'ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True, _
  13. 'IgnorePrintAreas:=False
  14. End Sub
Add Comment
Please, Sign In to add comment