One way is this example. It will place the path in the right footer section
on all pages in the current workbook. Copy and place in module. You can then
select this macro with an ALT+F8.

Sub FooterPath()

For Each Wksht In Worksheets
Wksht.PageSetup.RightFooter = Path
Next Wksht

End Sub

Hope this helps
Hal

"Arlene T" wrote:

In Excel is there a way to have the file path print on all worksheets
created. I would like to set it up to automatically insert the file path on
all documents. I have done the header/footer set up but it only prints on
one page unless I set it up on each page separately.

Thanks