how set cells don't print?

[Ian Elliott]

Thanks in advance!
I have some cells where the user inputs filenames and some
data that I don't want printed when the user prints the
worksheet. Is there a way to set certain cells not to
print even thought the whole worksheet is printed?
Thanks

 

[Paul Corrado]

Ian,

The whole worksheet is rather large, 16.8 million cells and printing the
entire sheet would take up many many pages (40,000-50,000), and would take a
few days for the job to be completed on a standard laser printer running at
10-15 pages per minute.

Usually people only use a portion of that space for their active work area.
Possibly you could set a print range that does not include the range where
this data is input.

PC

 

[Dave Peterson]

You could hide rows or columns so that they won't print. Does the user have to
see that other data at all?

Maybe just File|Print Area|Set Print Area (after you've selected the stuff you
want them to print.)

The user could override it, but they might not even care.