I have a working macro running from a command bar popup which prints all sheets with a yellow tab. It currently works only if the worksheets are visible. I would really like the code to work whether the tabs are visible or hidden.
Any help greatly appreciated. Code below:
Sub print_buttonyellow ()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
With ws
If .Tab.Color = vbYellow Then .Printout
End with
Next ws
End Sub
Any help greatly appreciated. Code below:
Sub print_buttonyellow ()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
With ws
If .Tab.Color = vbYellow Then .Printout
End with
Next ws
End Sub