Excel Header different on page one
 

Thank you! Thank you!! Thank you!!!

You have filled in the last piece of the puzzle as to how to create custom
headers that will be automatically generated in every new spreadsheet. The
only question I still have is whether there is a formatting code that will
produce the path name of the current file (similar to &F for the file name.)
Do you know?

Thanks again!
Hugh John Cook


"Ron de Bruin" wrote:

Hi Gossard

With VBA code it is possible
http://www.rondebruin.nl/print.htm#Header

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Gossard" wrote in message ...
I would like to make headers in excel but with the first page different than the other following pages. This can be accomplished
in Word, but is there a way to accomplish this in excel?

Excel Header different on page one
 

Excel 2002 and 2003 have a built-in path button on Custom Headers/Footers.

Prior to that you had to use a macro.

Sub Path_All_Sheets()
Dim ws asWorksheet
For Each ws In ActiveWorkbook.Worksheets
ws.PageSetup.RightFooter = ActiveWorkbook.FullName '_
' & " " & Chr(13) _
' & Application.UserName & " " & Date
Next ws
End Sub



Gord Dibben Excel MVP

On Fri, 9 Dec 2005 12:03:01 -0800, hjc wrote:

Thank you! Thank you!! Thank you!!!

You have filled in the last piece of the puzzle as to how to create custom
headers that will be automatically generated in every new spreadsheet. The
only question I still have is whether there is a formatting code that will
produce the path name of the current file (similar to &F for the file name.)
Do you know?

Thanks again!
Hugh John Cook


"Ron de Bruin" wrote:

Hi Gossard

With VBA code it is possible
http://www.rondebruin.nl/print.htm#Header

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Gossard" wrote in message ...
I would like to make headers in excel but with the first page different than the other following pages. This can be accomplished
in Word, but is there a way to accomplish this in excel?

Excel Header different on page one
 

Thanks, Gord. I already know about the built-in buttons on Custom
Header/Footer. What I am trying to do is automatically generate a custom
header every time I open a new spreadsheet, since I almost always want the
same information on it. That info includes the path, file name, worksheet
tab, date and time. By using a macro (defined in personal.xls, so it is
available to every spreadsheet) and a toolbar button to run it, I can now,
with the click of a button, insert the desired formatting codes into the
header for everything but the path. I can insert the path name as well, but
because I have to insert the actual name, instead of a formatting code, it
won't automatically update if I change the location of the file. This is
relatively minor in the overall scheme of things that I now know how to do,
because I don't often change the file location, but if there is a way to do
it, my happiness will be complete! (for now...in this very limited scope of
my work...I guess you probably know what I mean....)

Thanks again!
Hugh John



"Gord Dibben" wrote:

Excel 2002 and 2003 have a built-in path button on Custom Headers/Footers.

Prior to that you had to use a macro.

Sub Path_All_Sheets()
Dim ws asWorksheet
For Each ws In ActiveWorkbook.Worksheets
ws.PageSetup.RightFooter = ActiveWorkbook.FullName '_
' & " " & Chr(13) _
' & Application.UserName & " " & Date
Next ws
End Sub



Gord Dibben Excel MVP

On Fri, 9 Dec 2005 12:03:01 -0800, hjc wrote:

Thank you! Thank you!! Thank you!!!

You have filled in the last piece of the puzzle as to how to create custom
headers that will be automatically generated in every new spreadsheet. The
only question I still have is whether there is a formatting code that will
produce the path name of the current file (similar to &F for the file name.)
Do you know?

Thanks again!
Hugh John Cook


"Ron de Bruin" wrote:

Hi Gossard

With VBA code it is possible
http://www.rondebruin.nl/print.htm#Header

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Gossard" wrote in message ...
I would like to make headers in excel but with the first page different than the other following pages. This can be accomplished
in Word, but is there a way to accomplish this in excel?