Can anyone tell me how to get the filename in the footer automatically
in a new workbook.

Thanks!


--
cmorton89
------------------------------------------------------------------------
cmorton89's Profile: http://www.excelforum.com/member.php...o&userid=23103
View this thread: http://www.excelforum.com/showthread...hreadid=520524

Hi,

I don't see how you can change the usual blank workbook created by File-New.
However you could use 'New from template' on the task pane. You would have to
create template (really just an ordinary XLS) with the header/footer set &
save as an XLT. When you save as an XLT it should save the file to your
custom templates directory.

Regards,

Chris.

--
Chris Marlow
MCSD.NET, Microsoft Office XP Master


"cmorton89" wrote:


Can anyone tell me how to get the filename in the footer automatically
in a new workbook.

Thanks!


--
cmorton89
------------------------------------------------------------------------
cmorton89's Profile: http://www.excelforum.com/member.php...o&userid=23103
View this thread: http://www.excelforum.com/showthread...hreadid=520524