ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I prevent spicific visable cells from printing (https://www.excelbanter.com/excel-discussion-misc-queries/61340-how-do-i-prevent-spicific-visable-cells-printing.html)

Gazboe

How do I prevent spicific visable cells from printing
 
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.

Gord Dibben

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.



All times are GMT +1. The time now is 06:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com