Display but dont print cell

**mashley** · 06-27-2007, 05:04 PM

Is it possible for one cell from a print range to no be printed? I want the cell to display on the screen but not print. The cell is surrounded by many other cells that do need to print. The cell contents are current date and time displayed from the result of a Macro. Thanks.

**VBA Noob** · 06-27-2007, 05:10 PM

Does this link help

http://www.contextures.com/xlCondFormat03.html#Print

or you could add a text box and select the text box then in the formula bar enter = A1

Then format A1 as white font. Move the Text box over A1 then on text box properties tab deselect print object.

You may need to format the font of the text box as auto

VBA Noob

**mashley** · 06-27-2007, 05:46 PM

thanks for the help

**VBA Noob** · 06-27-2007, 05:53 PM

No problem

Another way would be an event macro

http://www.contextures.com/xlvba01.html#Workbook

Please Login or Register  to view this content.

VBA Noob

Display but dont print cell

LinkBack

Thread Tools

Rate This Thread

Display

Display but dont print cell

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions