is it possible to have certain cell values not print when printing?

I have a customer order worksheet that contains customer information, order
information, and pricing information. When I print the worksheet out, I
need everything except the pricing information to be seen on the printed
document. In essense I want to hide the pricing info from prying eyes but
maintain the rest of the documents info.

Thanks

GreenMonster, you could hide the columns or rows or change the font color to
white, or your paper color, and then print
this could all be done with a before print macro to hide or change the font
and then change it back after it prints
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"GreenMonster" wrote in message
...
is it possible to have certain cell values not print when printing?

I have a customer order worksheet that contains customer information,
order information, and pricing information. When I print the worksheet
out, I need everything except the pricing information to be seen on the
printed document. In essense I want to hide the pricing info from prying
eyes but maintain the rest of the documents info.

Thanks

See
http://www.rondebruin.nl/print.htm#Hide


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Paul B" wrote in message ...
GreenMonster, you could hide the columns or rows or change the font color to white, or your paper color, and then print
this could all be done with a before print macro to hide or change the font and then change it back after it prints
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"GreenMonster" wrote in message ...
is it possible to have certain cell values not print when printing?

I have a customer order worksheet that contains customer information, order information, and pricing information. When I print
the worksheet out, I need everything except the pricing information to be seen on the printed document. In essense I want to
hide the pricing info from prying eyes but maintain the rest of the documents info.

Thanks