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!

Gord Dibben Wrote:
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

On Wed, 14 Sep 2005 18:04:54 -0500, jake1729
wrote:


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


--
jake1729
------------------------------------------------------------------------
jake1729's Profile: http://www.excelforum.com/member.php...o&userid=27260
View this thread: http://www.excelforum.com/showthread...hreadid=467697