hiding cell values when printing.

G

GreenMonster

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
 
P

Paul B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Printing last entered values 1
Hiding cell values for printing 2
Automatically hiding rows with specific values 3
Cell values to an array, then array transpose to another workbook 8
HIDING A BUTTON 3
2007: How to disable printing when a specific cell is blank 8
Do I need Excel or Access for my database needs? 3
Is Access what I need for this database? 6

Top