Hiding a cell from printing in Excel 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Regards

Nevio
 
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
Click to expand...

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
 
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
 
You must log in or register to reply here.

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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Print macro that hides rows before printing 1
checkbox problem 22
Access Textbox - Hide Cursor 0
Excel 2007 print option gone 1
Can I save different print areas? 3
Conditionally Hide Rows 1
Code to hide rows if cell in another WS is ="No" 11

Back
Top