I have a simple Macro that can print in both Landscape & Potrait but has to use custom views to print. My spreadsheet has Subtotals in it and I'd like to print without the subtotals expanding which is currently happening. Can Anyone Assist? See my simple Macro below. Please Help.
Sub CommandButton1_Click()
ActiveWorkbook.CustomViews("custom print 1").Show
ActiveWorkbook.PrintOut
ActiveWorkbook.CustomViews("custom print 2").Show
ActiveWorkbook.PrintOut
MsgBox "Priting Complete"
End Sub
Thanks.
Sub CommandButton1_Click()
ActiveWorkbook.CustomViews("custom print 1").Show
ActiveWorkbook.PrintOut
ActiveWorkbook.CustomViews("custom print 2").Show
ActiveWorkbook.PrintOut
MsgBox "Priting Complete"
End Sub
Thanks.