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?