Can be done more simply with out check boxes
I have labels in A1:G1
I have data in A2:F100
The Print Area is set to A1:F100
G2:G100 has values either 0 or 1 (we could just as easily use x and blank)
I select A1:G100 and use Data | Filter | Auto Filter
I can filter the data on G so only row with G=1 are displayed or printed
Any use to you?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Paul Homer" <Paul wrote in message
...
Hi,

I want to insert a column of tick boxes that can be selected or deselected
so as to choose whether to print some rows and not others.

How do I do this?

Thanks
Paul