Opps!!!! The file location will only be seen when the sheet is printed and
when in print preview.

Mike Rogers

"Mike Rogers" wrote:

maicboy

If your template is saved as a template, right click on the icon and select
"open", (not "new"). You can now edit the template. goto "view"
"header/footer" in the page set up window select "footer", in the footer
select the "file name button" (second from the right with the excel "x" in
it). Ok out and save the template and close it. Now select the icon again
and either double click to open or right click and from the dropdown menu
select "New". This opens a "copy"of the template, from this "copy" you click
"save as" and save the new workbook to the file of your choice. The file
name will be changed in the footer to the locateion of this new workbook.
Does this help?

Mike Rogers

"maicboy123456" wrote:

I have a template saved, and I need to be able to prove that this template
is/was opened from a certain location. I know I can type a header/footer to
say what the file location is, but I need this information to only show when
it's printed. I also need it so that the worksheet cant be saved from the
template.(only printed)