Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How hide cells when print out?
Hi,
I have a range of cells I don't want to be printed. Today, I hide them with same colour for font and background and I thought it worked well - until todays discovery: Choosing Black/White printout, they are beeing printed! Therefore, have any of you an idéa how to "veryhidden" the cells, never to be printed? I can't temporary delete the cells, nor hide the rows or columns. I have some code pointing at the cells, so I can't just move them without a lot of work. Kind regards /Gunnar |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How hide cells when print out?
Hi
hiding should be no problem for your code :-) See ron's site for some prining code: http://www.rondebruin.nl/print.htm#Hide -----Original Message----- Hi, I have a range of cells I don't want to be printed. Today, I hide them with same colour for font and background and I thought it worked well - until todays discovery: Choosing Black/White printout, they are beeing printed! Therefore, have any of you an idéa how to "veryhidden" the cells, never to be printed? I can't temporary delete the cells, nor hide the rows or columns. I have some code pointing at the cells, so I can't just move them without a lot of work. Kind regards /Gunnar . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How hide cells when print out?
format the cells as
;;; -- Regards, Tom Ogilvy "Gunnar Johansson" wrote in message ... Hi, I have a range of cells I don't want to be printed. Today, I hide them with same colour for font and background and I thought it worked well - until todays discovery: Choosing Black/White printout, they are beeing printed! Therefore, have any of you an idéa how to "veryhidden" the cells, never to be printed? I can't temporary delete the cells, nor hide the rows or columns. I have some code pointing at the cells, so I can't just move them without a lot of work. Kind regards /Gunnar |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to show columns/cells in sheet but hide them in print? | Excel Discussion (Misc queries) | |||
Hide a row and set print area | Excel Worksheet Functions | |||
HIDE WHEN I PRINT | Excel Discussion (Misc queries) | |||
hide print box | Excel Programming | |||
Hide or disable print | Excel Programming |