Text in a cell visable on screen but BUT doesn't get printed

[T.I.M.]

[Fixed]
How can I show the 1st 3 rows off the ,,first'' worksheet, on each new worksheet?

So it's some sort of Header?
[Fixed]


And another question:
How can I enter text in a cell that I can see on screen but doesn't get printed?
I don't like that comment thing in Excel, because you only see the/that comment when the corresponding cell is active.



great thanks,
Tim

 

[TommyGun]

Re: Show the 1st 3 rows on each (new) worksheet

When it prints, or all the time?

 

[T.I.M.]

WOW, that's really quick... )

When it prints
(I know how to Freeze the title)

 

[T.I.M.]

/Me is a little stupid

How can I show the 1st 3 rows off the ,,first'' worksheet, on each new worksheet?

So it's some sort of Header?

Fixed it => PageSetup, Worksheet, rows on top of each page!





BUT... still I need to get this figured out:
How can I enter text in a cell that I can see on screen but doesn't get printed?
I don't like that comment thing in Excel, because you only see the/that comment when the corresponding cell is active.



greetings,
Tim

 

[DRJ]

Hi - Welcome to the board

You can set the print area and not include the cells you don't want to print. You will still see them on the screen, but they will not print out.

File | Print Area | Set Print Area

 

[T.I.M.]

Doesn't seem to work?

??? then I get it on 2 different pages instead of 1?

 

[T.I.M.]

that won't work

No I can't get it to work that way (with define print area)

 

[Scott Huish]

Re: Text in a cell visable on screen but BUT doesn't get pri

Which cells are you trying to hide?

 

[Chas17]

Re: Text in a cell visable on screen but BUT doesn't get pri

You could try making the cell font white before print and change it back like:
for cell A4
In the vbCode:

Workbook section:

Private Sub Workbook_BeforePrint(Cancel As Boolean)
'Chas Weber 4/9/04
Range("a4").Font.Color = vbWhite
End Sub

Private Sub Workbook_Open()
'Chas Weber 4/9/04
Range("a4").Font.Color = vbBlack
End Sub

In the Sheet section for sheet cell is on:

Private Sub Worksheet_Activate()
'Chas Weber 4/9/04
Range("a4").Font.Color = vbBlack
End Sub

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'Chas Weber 4/9/04
Range("a4").Font.Color = vbBlack
End Sub

 

[T.I.M.]

Re: Text in a cell visable on screen but BUT doesn't get pri

@Chas17:
WORKS!!!!!!! GREAT MAN!
You're my Hero! :wink:

Only one little thing left (not a real problem)
The tekst only turn black when you click somewhere in the sheet, can't it get black again when you drop back from in the sheet from the print menu?


@Hotpepper:
I would like to hide row 2 and 3 from my printer so I can use these rows to put comments in.



greetings.
Tim