Limiting Printing to certain sheets...

S

Steve Hillin

I have a 7-sheet workbook that I want to print, but one of the sheets
I don't want printed. It must stay visible, so hiding it is not an
option. I can make the print area a blank cell, but this prints a
blank page, also not good. What can I do?
 
D

Don Guillett

for each ws in worksheets
if ws.name <>"dontprintthisone" then ws.printout
next
 
Top