I posted the same question in another forum, may I have better chances
here... How I can avoid to print some cells?

Hi Fernando

You can use the beforeprint event to make text white or hide columns
I have some small examples on this page

http://www.rondebruin.nl/print.htm


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Fernando Duran" wrote in message ...
I posted the same question in another forum, may I have better chances
here... How I can avoid to print some cells?

If the cells can't been hidden by hiding a whole row or column and are part
of the print area you actually can't as far as I know.
What you can do is format the cell content to an colour equal to the
background (probably white).

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

"Fernando Duran" wrote in message
...
I posted the same question in another forum, may I have better chances
here... How I can avoid to print some cells?

Thanks, good idea... thanks again


On Wed, 28 Jan 2004 22:05:59 +0100, "Ron de Bruin"
wrote:

Hi Fernando

You can use the beforeprint event to make text white or hide columns
I have some small examples on this page

http://www.rondebruin.nl/print.htm