Prevent Single Worksheet from Printing
 

I need to be able to print all worksheets in an excel spread sheet
except for one. Can this be achieved programatically?

Prevent Single Worksheet from Printing
 

something like

sub printallbutone()
for each ws in worksheets
if ws.name<"Dontprintthisone" then ws.printout
next ws
end sub


--
Don Guillett
SalesAid Software

"Epoh Rio" wrote in message
ups.com...
I need to be able to print all worksheets in an excel spread sheet
except for one. Can this be achieved programatically?

Prevent Single Worksheet from Printing
 

Thanks for the quick reply. Where do insert this code? This workbook?

Prevent Single Worksheet from Printing
 

That's OK. But, probably best in a regular module.
Just make sure you get the name of the worksheet right
"Sheet2" is NOT the same as "sheet2"
--
Don Guillett
SalesAid Software

"Epoh Rio" wrote in message
ups.com...
Thanks for the quick reply. Where do insert this code? This workbook?

Prevent Single Worksheet from Printing
 

Thanks I will give it a try