View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Earl Kiosterud Earl Kiosterud is offline
external usenet poster
 
Posts: 611
Default Creating a default for all new workbooks

Tasha,

You need to have saved your workbook as a template (in the file type box), named it
book.xlt, and put it in the XLStart folder. You can use either the XLStart folder in your
user path of the Documents and Settings folder, or in the one in Program Files path,
depending on whether it's' for one user or all.

--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Tasha" wrote in message
...
I'm needing to create a default in Excel so that every new workbook that is
created up in my department, automatically has the path & file name displayed
in the footer of every sheet.

I've tried setting up a template, but I can't seem to make it work.