print question

[bam12]

is there a way to print a workbook but not to print certain sheets within that worklbook without doing a macro?

If have to do a macro, could you direct me in where to look for an answer

Thanks

 

[TrippyTom]

Just select the tabs (sheets) you DO want to print and in your print window choose ACTIVE SHEETS.

 

[Datsmart]

You can print just selected worksheets.
Ctrl-Click just the worksheet tabs you want to print. Then Click print and make sure under "Print What" it reads "Active Sheets".

 

[bam12]

Thanks

Thanks i knew that, but person that wants this does not want to do tha evertime he want to print, i was wondering if a macro could be made up

 

[Datsmart]

Yes, code could be used.
Will the same worksheets always be printed? If so, will there be a list of their names somewhere or would that need to be hard coded into the code? Maybe a list of the sheets NOT being printed would be shorter. If so, can you post them?