| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linked Checkboxes
I currently have several checkboxes that are linked to the cell below them. The cell references an HLOOKUP formula that = "Yes". My problem is that when I print the worksheet, the TRUE and FALSE values for the cells that the checkboxes are linked to print. I've changed the font to white, but they still print. Thanks in advance. -ep -- edwardpestian ------------------------------------------------------------------------ edwardpestian's Profile: http://www.excelforum.com/member.php...o&userid=33809 View this thread: http://www.excelforum.com/showthread...hreadid=566247 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Linked Checkboxes
Why not just set a print area, and put them outside that print area?
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "edwardpestian" wrote in message news:edwardpestian.2bp5po_1154159704.0309@excelfor um-nospam.com... I currently have several checkboxes that are linked to the cell below them. The cell references an HLOOKUP formula that = "Yes". My problem is that when I print the worksheet, the TRUE and FALSE values for the cells that the checkboxes are linked to print. I've changed the font to white, but they still print. Thanks in advance. -ep -- edwardpestian ------------------------------------------------------------------------ edwardpestian's Profile: http://www.excelforum.com/member.php...o&userid=33809 View this thread: http://www.excelforum.com/showthread...hreadid=566247 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Linked Checkboxes
I had thought of doing that; however, I wanted to find out if there was another way that I was overlooking. -ep -- edwardpestian ------------------------------------------------------------------------ edwardpestian's Profile: http://www.excelforum.com/member.php...o&userid=33809 View this thread: http://www.excelforum.com/showthread...hreadid=566247 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Linked Checkboxes
KISS <g
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "edwardpestian" wrote in message news:edwardpestian.2bpju2_1154178006.5049@excelfor um-nospam.com... I had thought of doing that; however, I wanted to find out if there was another way that I was overlooking. -ep -- edwardpestian ------------------------------------------------------------------------ edwardpestian's Profile: http://www.excelforum.com/member.php...o&userid=33809 View this thread: http://www.excelforum.com/showthread...hreadid=566247 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Linked Checkboxes
I like to give the cell a custom format of:
;;; (3 semi colons) ===== And are you printing in B&W? edwardpestian wrote: I currently have several checkboxes that are linked to the cell below them. The cell references an HLOOKUP formula that = "Yes". My problem is that when I print the worksheet, the TRUE and FALSE values for the cells that the checkboxes are linked to print. I've changed the font to white, but they still print. Thanks in advance. -ep -- edwardpestian ------------------------------------------------------------------------ edwardpestian's Profile: http://www.excelforum.com/member.php...o&userid=33809 View this thread: http://www.excelforum.com/showthread...hreadid=566247 -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Linked Checkboxes
Yes, I am printing in B&W. -ep -- edwardpestian ------------------------------------------------------------------------ edwardpestian's Profile: http://www.excelforum.com/member.php...o&userid=33809 View this thread: http://www.excelforum.com/showthread...hreadid=566247 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Linked Checkboxes
Try printing in color.
File|page setup|sheet tab|uncheck black and white. (or try that ;;; custom number format) edwardpestian wrote: Yes, I am printing in B&W. -ep -- edwardpestian ------------------------------------------------------------------------ edwardpestian's Profile: http://www.excelforum.com/member.php...o&userid=33809 View this thread: http://www.excelforum.com/showthread...hreadid=566247 -- Dave Peterson |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Linked Checkboxes
I really need print in black and white as I'm printing to a B&W laser printer and I don't want any of the colored cells to come out grayscale. Using you custom format (;;;) worked. Thanks.. -ep -- edwardpestian ------------------------------------------------------------------------ edwardpestian's Profile: http://www.excelforum.com/member.php...o&userid=33809 View this thread: http://www.excelforum.com/showthread...hreadid=566247 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linked Cells Staying With Cells Once Linked Workbook Update. | Excel Worksheet Functions | |||
| Replacing Linked Cell Values w/ Current Values | Excel Worksheet Functions | |||
| Why sometimes excel returns error just because function parameters are linked? | Excel Worksheet Functions | |||
| How do I automatically open linked documents in Excel? | New Users to Excel | |||
| Use checkboxes with linked external data? | Excel Discussion (Misc queries) | |||
Hybrid Mode
