I would like to create a button and assign a macro that automatically prints
all visible sheets but doesn't print hidden sheets. What should the vb
syntax look like that would accomplish this and run the fastest? I want to
avoid having to provide the name of the visible sheets if possible because
there are different scenarios and I won't know what sheets are visible at any
given time. If this is not possible, I need to know how to write the syntax
to say if sheet named X is visible, then print, otherwise don't print.

Use
Sub printVisible()
For Each ws In Worksheets
If ws.Visible = True Then
'Your Print commands
End If
Next ws
End Sub
-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"Lisa C." wrote:

I would like to create a button and assign a macro that automatically prints
all visible sheets but doesn't print hidden sheets. What should the vb
syntax look like that would accomplish this and run the fastest? I want to
avoid having to provide the name of the visible sheets if possible because
there are different scenarios and I won't know what sheets are visible at any
given time. If this is not possible, I need to know how to write the syntax
to say if sheet named X is visible, then print, otherwise don't print.