Page Header

J

jake1729

Is there a way to refer to a specific cell from the page header WITHOUT
using VBA? Thank you!
 
G

Gord Dibben

No.

What's wrong WITH using VBA?

Just in case you change your mind...........

Sub CellInHeader()
With ActiveSheet
.PageSetup.CenterHeader = .Range("A1").text
End With
End Sub


Gord Dibben Excel MVP
 
J

jake1729

Gord,
I have an Excel file that is very simple. I want any user to be able
to open the Excel file without any warnings. The type of people
receiving the Excel file are computer literate just enough to open
Excel and type in some data.

On a side note, why do you think this is not available? Or why will
the shortcut "Ctrl-E" not center text in a cell. I am a computer
science student so such 'errors' interest me. Thanks!
 
Top