Group:  Microsoft Excel ยป microsoft.public.excel
Thread: Hide two cells until print

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

Hide two cells until print
Jeannine 05.09.2006 18:50:01
I would like to be able to hide the contains of two cells when on the screen
but have it show when it is printing.

Anybody have any ideas?
Re: Hide two cells until print
"Bob Umlas" <Excel_Trickster[ at ]msn.com> 05.09.2006 19:48:38
Give it a white font, and in the Workbook_BeforePrint event, change the font
to black, set up an ontime event to turn it back to white after printing.

"Jeannine" <Jeannine[ at ]discussions.microsoft.com> wrote in message
news:E7F12542-AE54-4894-8E2C-51FA0F45AC99[ at ]microsoft.com...
[Quoted Text]
> I would like to be able to hide the contains of two cells when on the
screen
> but have it show when it is printing.
>
> Anybody have any ideas?


Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net