Hi,

Please see my code below. I do not know how to write this code. I have 2 worksheets.

If I am on sheet1 and I want to print this workbook, I want to activate the other sheet first. How to do that ? 

Private Sub Workbook_BeforePrint(Cancel As Boolean)
If Sheet2.Select = True Then
Sheet1.Activate
Else: Sheet2.Activate
End If
Workbook.save
End Sub