Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 47
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to show columns/cells in sheet but hide them in print? Jeff Korn Excel Discussion (Misc queries) 8 May 25th 08 05:54 PM
Hide a row and set print area shiro Excel Worksheet Functions 0 January 22nd 08 06:14 AM
HIDE WHEN I PRINT qwerty Excel Discussion (Misc queries) 2 November 2nd 05 12:56 AM
hide print box Tom Ogilvy Excel Programming 0 April 20th 04 01:07 PM
Hide or disable print Gareth[_3_] Excel Programming 1 February 14th 04 12:05 PM


All times are GMT +1. The time now is 07:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"