Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Page Header
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 |
#2
|
|||
|
|||
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! |
#3
|
|||
|
|||
No.
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 -- Dave Peterson |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I setup a header in Excel that prints only on first page? | Excel Discussion (Misc queries) | |||
header and footer on every page except the first page? | Excel Discussion (Misc queries) | |||
changing page numbers in repeated header | Excel Discussion (Misc queries) | |||
How do I keep the header on the first page but hide it on the sec. | Excel Discussion (Misc queries) | |||
Default header in Excel under page set-up | Excel Discussion (Misc queries) |