Set a header/footer as default

D

DanM

A co-worker asked if it was possible to set default header and footer in Excel 2k. I can't figure out to do this short of creating a macro.
Before I do that, though, does anyone know how to set up a default header and footer that would appear on each new worksheet? Somethng I haven't spotted under Tool> Options, perhaps?
 
R

Ron de Bruin

One way is to create a template an name it "Book"

If you have the Book.xlt in the Xlstart folder all new
workbooks are created from this template.

See also this code example to add the last saved time, you can copy this in the template.
Maybe you can use it
http://www.rondebruin.nl/print.htm#Saved

--
Regards Ron de Bruin
http://www.rondebruin.nl


DanM said:
A co-worker asked if it was possible to set default header and footer in Excel 2k. I can't figure out to do this short of creating a macro.
Before I do that, though, does anyone know how to set up a default header and footer that would appear on each new worksheet?
Click to expand...
Somethng I haven't spotted under Tool> Options, perhaps?
 
Top