How can I not print formulated text, see what I mean

[TonyU]

Is it possible not to print text on a cell ??

Example:I have this checkbox on cell N6 displaying the text you see here. Just like I have the checkbox not printing, I would like to NOT print the text attached, how?

Obviously, this is only a user friendly message and do not need printing.

=IF(Q2=FALSE,"Check this box if shipping address will not be The Company's","SHIP ITEM(S) TO ADDRESS BELOW&quot



Thanks

[tt]"A Successful man is one who can build a firm foundation with the bricks that others throw at him"[/tt]

​

 

[DaleWatson123321]

Hi Tony,

You just have to:

1) right-click on the Text Box (on the border of it)

2) click the "Properties" tab

3) then de-select "Print object".

Hope this helps.

Regards, ...Dale Watson

HOME: nd.watson@shaw.ca

 

[TonyU]

[tt] Thanks Dale but I'm already doing that, the text sits outside the checkbox, but while I type this I thought, why the heck don't I place the text within the text box and be done with it Duh!!

Brain fart

[tt]"A Successful man is one who can build a firm foundation with the bricks that others throw at him"[/tt]

​

 

[uberpudge]

Hello Tony,

Have you tried intercepting the "BeforePrint" event?
Example:

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Dim strFormula As String

strFormula = Range("N6&quot.Formula
Range("N6&quot.ClearContents

Sheet1.PrintOut

Range("N6&quot.Formula = strFormula
Cancel = True
End Sub

Hope this helps,
Pete