ExcelBanter - Print pink sheets

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Print pink sheets (https://www.excelbanter.com/excel-programming/366458-print-pink-sheets.html)

Steph

Print pink sheets

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

Tom Ogilvy

Print pink sheets

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

--
Regards,
Tom Ogilvy

"Steph" wrote:

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

All times are GMT +1. The time now is 03:13 PM.