Dean

That would depend upon which version of Excel you are running.

If earlier than 2000, you would need a macro to add the filename to a
footer/header.

Otherwise, Frank and Spencer have covered it.

Gord Dibben Excel MVP

On Wed, 22 Dec 2004 07:35:04 -0800, "Dean"
wrote:

I have a template on a network drive so users can enter data and save as that
particular part number as the file name...i later go and print them off....is
there away to have the wrksheets automatically have the filename print as the
header? is it something i put in the template?

thanks