Macro to only Print Worksheets that are tabbed the same color

[jmart2210]

I have a spreadsheet that the tabs are color coded based on their use. I need a macro that selects and prints only the sheets that are of a certain color. The names of the worksheets can change. Any advice to get started?

[jmart2210]

I don't have much excel experience, but I was thinking of starting like this:

Please Login or Register  to view this content.

[Andy Pope]

you could use a function to get a reference to the sheets matching

Please Login or Register  to view this content.

[jmart2210]

That worked perfectly. Was there any purpose in the MsgBox pop-ups, other than letting you know what sheets were being printed? I didn't need that functionality, so I removed that snippet of code, but thanks a ton.

[Andy Pope]

msgbox was only for illustration, safe to remove.