Limiting Printing to certain sheets...

  • Thread starter Thread starter Steve Hillin
  • Start date Start date
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?
 
for each ws in worksheets
if ws.name <>"dontprintthisone" then ws.printout
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 Different Sections of same Sheet 1
Certain worksheets won't print 1
How to best select from image and print full size? 1
Print Area to include text box 10
Blank Sheet with Gridlines 11
Printing multiple sheets... 1
Print titles must be contiguous and complete rows or columns 18
Print Visible Sheets Macro 1

Back
Top