Home |
Search |
Today's Posts |
#9
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Print and Print Preview Graphic Moving Resizing 2007/2003 | Excel Discussion (Misc queries) | |||
cell borders that I create dont show on print preview or print | Excel Discussion (Misc queries) | |||
Pivot Table macro to set print area and print details of drill down data | Excel Discussion (Misc queries) | |||
Active cell counting in particular print page (one sheet having different print area) | Excel Worksheet Functions | |||
Macro to open print window and set to print entire workbook | Excel Discussion (Misc queries) |