I want to print sheet1 and sheet2 with one button i have code for one sheet please modify for two sheet thanks Private Sub CommandButton2_Click() ActiveWindow.SelectedSheets.PrintOut ' print End Sub