Mass print based upon value in one cell for each tab

[csmithbuffalo]

I have close to 50 tabs on one workbook that is used to calculate overtime pay for employees. I have the total pay in the same cell for each tab. I want to be able to print the whole workbook IF that cell has a value- meaning if they had overtime pay, i need to print that sheet. If they did not, of course, there is a zero in that cell, therefore do not need to print. How can i execute this with one process. VBA? but what would the code be? thanks for any and all help!

 

[Candyman8019]

You can try something like this:

Sub PrintOvertime()
Dim ws As Worksheet
  For Each ws In ThisWorkbook.Worksheets
    If ws.Range("H2").value = 0 Then  'Change H2 to the correct cell in your sheets.
      ws.PrintOut
    End If
   Next ws
End Sub