Here's a possible solution:

1. Use checkboxes from the Forms Toolbar; not the Control Toolbox (the
former are more stable when used on worksheets). Ypu will probably want to
uncheck "Print Object" in the Format Control dialog.

2. Right-click on each one and set its LinkedCell property to a cell in the
row that the checkbox relates to (say in column Z, if that's far enough
out). You can even hide the column as it serves no purpose other than to
carry the value of the checkboxes.

3. Put the following code in the ThisWorkbook code module:

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Dim c As Range
With ActiveSheet
For Each c In Intersect(.UsedRange, .Range("Z:Z"))
If c = True Then c.EntireRow.Hidden = True
Next
Application.EnableEvents = False
On Error GoTo ErrorHandler
.PrintOut
Application.EnableEvents = True
End With
ErrorHandler:
MsgBox "Error " & Err.Number & vbNewLine & Err.Description, _
vbOKOnly + vbCritical, "Error"
ActiveSheet.UsedRange.EntireRow.Hidden = False
Application.EnableEvents = True
End Sub

It's really pretty messy but hopefully will put you on the right track.

--

Vasant







"nman" wrote in message
...
I tried the code for "Hide Rows or Cells when you print a
sheet" and it did not work for me.

-----Original Message-----
Try this
http://www.rondebruin.nl/print.htm#Hide



--
Regards Ron de Bruin
http://www.rondebruin.nl


wrote in message
...
New to this but I do understand your comments. Not
sure
what the code should be to not print a row (or range).

-----Original Message-----
You would have to write code to hide the row in order
for it not to be
printed. Also, how would you "reference" a row from a
checkbox? You would
probably need to use a linked cell to identify the row
that you want to
suppress.

--

Vasant


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


.



.