Check out similar discussion here.

http://snipurl.com/htvh


Gord Dibben Excel MVP

On Tue, 20 Sep 2005 13:23:01 -0700, "excel?s"
wrote:

Is there a way that you can apply header/footer settings to all workbooks
that you create?