How to omit certain worksheets in a series from printing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Macro Solutions - 25 Jun 2006 17:35 GMT

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

Reply to this Message

galimi - 25 Jun 2006 21:44 GMT

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.

Signature

http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758

> 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

Reply to this Message