Print Question

[Aargh!!]

Good Afternoon,
I am trying to find how to "mark" the contents of a cell or row so that I can see the contents on the screen but when I print the document, the contents are hidden. I don't want to hide the row. Is there any other way I can do this?

Many thanks

[Barrie Davidson]

On 2002-02-19 07:40, Aargh!! wrote:
Good Afternoon,
I am trying to find how to "mark" the contents of a cell or row so that I can see the contents on the screen but when I print the document, the contents are hidden. I don't want to hide the row. Is there any other way I can do this?

Many thanks

You can do this in VBA. How are you planning on "marking" the rows you don't want to print?

[Aargh!!]

Within Lotus, I understand it is possible to "mark" the cell contents with " ¦¦ " and this allows contents to be seen but not printed. Is this VBA method fairly simple / idiot proof? It'll need to be!
Thanks again

[Juan Pablo González]

Have a look at this:

http://www.mrexcel.com/tip033.shtml

[Barrie Davidson]

On 2002-02-19 08:49, Aargh!! wrote:
Within Lotus, I understand it is possible to "mark" the cell contents with " ¦¦ " and this allows contents to be seen but not printed. Is this VBA method fairly simple / idiot proof? It'll need to be!
Thanks again

In attempting to come up with a solution, I have identified a potential problem. I can easily hide a row before printing, but the user would have to manually unhide the rows after printing (not idiot proof). If you'd like, I can provide the code to hide a row before printing.