Making cells appear on screen but NOT print
 

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

How do I do that?

Making cells appear on screen but NOT print
 

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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

You could put them in some "empty rows" above your data or over to the side of your data and then set the print area to not include those rows/columns.

Making cells appear on screen but NOT print
 

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


On Jun 7, 3:04*am, Cat Slave
wrote:
I need to have a macro button and a text cell that appear on the screen
but not appear when printing.

How do I do that?

--
Cat Slave

Thanks for the replies. It worked.
thanks

Making cells appear on screen but NOT print
 

On Thursday, June 7, 2012 at 10:30:21 PM UTC+5:45, Bob Flanagan wrote:
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


On Jun 7, 3:04*am, Cat Slave
wrote:
I need to have a macro button and a text cell that appear on the screen
but not appear when printing.

How do I do that?

--
Cat Slave

Where to Right click? where is context menu format control ...

Making cells appear on screen but NOT print
 

On Friday, June 8, 2012 at 12:45:21 AM UTC+8, Bob Flanagan wrote:
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


On Jun 7, 3:04Â*am, Cat Slave
wrote:
I need to have a macro button and a text cell that appear on the screen
but not appear when printing.

How do I do that?

--
Cat Slave

"Hold down CTL key and click on the button" What button? i cant seem to find the print check box for an ordinary cell (or column or line). I can only fidn the print check box on Text box.

Liên hệ với mình nha
_________________
máy xay cÃ* phê chuyên nghiệp

https://t.co/0l0e8sXm4L