Thread: Print Row
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
 
Posts: 2,824
Default Print Row

It might be to use Data|filter|Autofilter.

Apply the filter to a column and show only the rows you want to print.

I'd drop the checkboxes and use a simple X in that column of cells.
(Filter by Blanks or non-blanks)

But you could make each checkbox link to a cell in that row.
(Then you'd filter by True/False)

(if you exclude that column from the print range, it'll look ok.)

A little extra work, but I think it's easier.



nman wrote:

I am searching for code that I can attach to a checkbox
that will not allow a referenced row to be printed. Any
advice?


--

Dave Peterson