hiding cell values when printing.

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message news:%[email protected]...
> 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" <[email protected]> wrote in message news:[email protected]...
>> 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
>>
>
>