Perhaps you could use conditional formatting to change the font colour
to white, for the rows that you don't want to print. There's an example
here, that you could adapt:
http://www.contextures.com/xlCondFormat03.html#Print
In addition to having one main cell with an "x", you could use the first
column to mark the rows that shouldn't be printed. Change the formula to
check the main cell, and the cell in column A, e.g.:
=AND($H$1="x",$A2="x")
nman wrote:
I have seen applications that contain checkboxes for
building "task" list for equipment maintenance that
allowed you to use the checkbox to select if you want to
print or not print a row (include or not include the
task). Thanks for your help.
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html