ExcelBanter - Hide Text When Printing

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Hide Text When Printing (https://www.excelbanter.com/excel-discussion-misc-queries/143305-hide-text-when-printing.html)

Erika

Hide Text When Printing

Is there a way that you can mark a column so when you view it on screen it
will display however when you print it - it will not print?

Erika

Gord Dibben

Hide Text When Printing

Check out ViewCustom Views

You can have many views of the same sheet.

Add one for printing only.

Alternative is VBA Before_Print code which would hide the column, print, then
unhide.

Gord Dibben MS Excel MVP

On Fri, 18 May 2007 13:11:01 -0700, Erika
wrote:

Is there a way that you can mark a column so when you view it on screen it
will display however when you print it - it will not print?

Erika

All times are GMT +1. The time now is 03:49 PM.