Sub printsheet() Dim i As Integer For i = 1 To Sheets.Count Sheets(i).Select If Sheets(i).Tab.ColorIndex = "27" Then ActiveSheet.PrintOut End If Next End Sub
Sub printsheet() Dim i As Integer For i = 1 To Sheets.Count Sheets(i).Select If Sheets(i).Tab.ColorIndex = "27" Then ActiveSheet.PrintOut End If Next End Sub