View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default How do I prevent spicific visable cells from printing

FormatCustom ;;; (three semi-colons)

The text won't show in the cell or on a print-out.

The hyperlink will still work.

You can always clear the formatting after printing.


Gord Dibben Excel MVP

On Tue, 20 Dec 2005 16:51:02 -0800, Gazboe
wrote:

I have a cell that is setup as a hyperlink and has text in it to show its
function. However I would like to prevent this cell form appearing on any
printed form. Can any one explain how to acheive this.