Print when check box checked
 

Hi - I am a new boy to this forum and I hope your expertise can help me
with my problem.

I have a excel document with text in cells- I want to be able to assign
a check box to each cell and when I print it only prints those cells
checked.

Is this possible and if so how?????

Regards
Vince :cool:


--
vincenealon
------------------------------------------------------------------------
vincenealon's Profile: http://www.excelforum.com/member.php...o&userid=23754
View this thread: http://www.excelforum.com/showthread...hreadid=374131

Hi Vince

Add a link from your text box to a corresponding cell so each cell in a
column has TRUE or FALSE as a value. Now do an advanced filter hiding
all rows which have FALSE in your helper cell. You can hide your
helper column as you wouldn't want to print that.

Hope this helps
Martin


--
MartinShort

Software Tester
------------------------------------------------------------------------
MartinShort's Profile: http://www.excelforum.com/member.php...o&userid=22034
View this thread: http://www.excelforum.com/showthread...hreadid=374131