View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
create a new workbook with this header and save it as template ('*.xlt'
file)

--
Regards
Frank Kabel
Frankfurt, Germany

Melanie wrote:
I have several worksheets within one workbook. I want to be able to
set-up a default header that I can use on each worksheet without
having to type the same information on each Page Set-up under the
header information. Is thier a way to set a default header for the
whole workbook or at the very least to put a "default header" in the
drop down box to choose the header I want on each workbook?