Thread: Print Row
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default Print Row

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