Print pink sheets

S

Steph

Hi. Is there a way to print all sheets in a workbook that have a specific
tab color? For instance, color index 38? Thanks!
 
T

Tom Ogilvy

for each sh in Activeworkbook.Worksheets
if sh.tab.colorIndex = 38 then
sh.printout
end if
Next
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Printing from Word my Inserted Pictures colors are dull and lack color 0
Print order of TriFold - Publisher 365 0
macOS Office365 Word 0
Publisher adding blank page when printing my booklet... 2
Remove Hyperlinks Without Changing background shading 14
table shading prints differently on different pages 0
Tracked changes by multiple people modified to one 0
Update several ppt documents from a single excel file 0

Top