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

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?

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

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?

Thanks I will give it a try