John Walkenbach has a utility that can add the path name to the footer of the
activesheet.

Maybe you could modify it to do all you wanted.

http://j-walk.com/ss/excel/files/addpath.htm

Paul Canal wrote:

Thanks Dave, I will give that a try.

What I am hoping to do is set a default so that whenever a spreadsheet (or
for that matter Office) document is printed, it includes the filename and
author without having to do it for each document, but your fix certainly
would save time multi tabbed documents, of which sadly I have far to many!.

"Paul Canal" wrote:

Currently I have to go down the view/header& footer/custom route for each tab
on each worksheet.

Is there a default setting that includes it automatically?

--

Dave Peterson