How to omit certain worksheets in a series from printing
 

I have set up a macro to print several worksheets in a Excel workbook.
How do I omit a sheet fom printing if it reflects a zero value in a certain
cell

How to omit certain worksheets in a series from printing
 

You can surround the print macro with the following condition.

If range("range").value < 0 then

print macro here...

end if

range("range") should be replaced with the range/cell you are referencing.
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758


"Macro Solutions" wrote:

I have set up a macro to print several worksheets in a Excel workbook.
How do I omit a sheet fom printing if it reflects a zero value in a certain
cell