Hiding a cell from printing in Excel 2003

N

Nevio

Is it possible to hide selected cells within a workbook from printing in
Excel 2003 and how can this be done?

Regards

Nevio
 
F

Franz Verga

Nevio said:
Is it possible to hide selected cells within a workbook from printing
in Excel 2003 and how can this be done?

Regards

Nevio

Hi Nevio,

You cannot hide single cells, but entire rows/columns. You can change the
font colour in the cell so it becoms equals to background of the cell. You
can use the Workbook_BeforePrint event to control the changing of colour or
hiding/displaying rows/coloumns.


Because from your name I think you could be Italian, I tell you that there
is also an Italian speaking newsgroup:

microsoft.public.it.office.excel

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
N

Nevio

Franz,

yes, I am an italian who has been living in Australia for 52 years, so
English is OK for me.

Many thanks and regards.

Nevio Margon
 
Top