Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 -- vincenealon ------------------------------------------------------------------------ vincenealon's Profile: http://www.excelforum.com/member.php...o&userid=23754 View this thread: http://www.excelforum.com/showthread...hreadid=374131 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
One spreadsheet cell won't print but shows up in print preview? | Excel Discussion (Misc queries) | |||
How do I restrict only 1 of 2 check boxes be checked? | Excel Discussion (Misc queries) | |||
Print and Print Preview don't match screen | Excel Worksheet Functions | |||
set the print area print multiple tabs | Excel Discussion (Misc queries) | |||
Printing - Have to set print area 1 column further than necessary | Excel Discussion (Misc queries) |