Making cells appear on screen but NOT print

[Cat Slave]

I need to have a macro button and a text cell that appear on the scree
but not appear when printing.

How do I do that

 

[Claus Busch]

Hi Cat,

Am Thu, 7 Jun 2012 07:04:43 +0000 schrieb Cat Slave:

I need to have a macro button and a text cell that appear on the screen
but not appear when printing.

if it is a complete row or column you can hide it before printing. Only
a few cells I would turn the font color to white before printing and
after printing turn it back to automatic.


Regards
Claus Busch

 

[Bob Flanagan]

Hold down the CTL key and click on the button, and then right click
to see the context menu. Select Format Contol. Uncheck under
properties the print checkbox. If you add a text box instead of
text in a cell, you can set the text box to not print also.

Robert Flanagan
Add-ins.com LLC
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

 

[Cat Slave]

;1602475']Hold down the CTL key and click on the button, and then righ
click
to see the context menu. Select Format Contol. Uncheck under
properties the print checkbox. If you add a text box instead of
text in a cell, you can set the text box to not print also.

Robert Flanagan
Add-ins.com LLC
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

I need to have a macro button and a text cell that appear on th screen
but not appear when printing.

How do I do that?

Thanks for the replies. It worked.
thank