Print button in Excel

Brother 3/4in white on black tape for al...
July 21, 2009 at 03:15:34
Specs: Windows XP
I have the following program to add to a button to print a sheet in Excel:
Private Sub CommandButton1_Click()
Sheets("Sheet2").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True

End Sub

However, after I print I return to the printed sheet, and I would like to return to the sheet I printed from instead, how do I do that?


See More: Print button in Excel

Report •


#1
July 21, 2009 at 06:26:14
Private Sub CommandButton1_Click()
sheets("sheet2").printout
End sub

Report •
Related Solutions


Ask Question