Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Las Vegas, Nevada, USA
    Posts
    334
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Header/Footer Defaults (Excel 97)

    Can Excel 97 print settings such as header and footer be stored in a file so that each each new file opened uses those settings. I know a macro will achieve these results. I also have recently seen how a template file can work (when selecting File-New, but not from the New File icon). But I am looking for a workbook solution, perhaps in XlStart or something similar. Thx

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Header/Footer Defaults (Excel 97)

    You can set up a default template for all new workbooks. Set the book up as you require with formatting etc. including any Header & Footer you want as default. Save the book in your startup directory, usually ...OfficeXLStart, as Book.xlt. You can aslo save a single sheet book as Sheet.xlt, which will become the default for any new sheets you insert into any workbook.

    Andrew C

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Las Vegas, Nevada, USA
    Posts
    334
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Re: Header/Footer Defaults (Excel 97)

    Thanks Andrew! Thats just what I was looking for.

  4. #4
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Header/Footer Defaults (Excel 97)

    <P ID="edit" class=small>Edited by WebGenii on 24-Aug-01 16:33.</P>You might also take a look at the Custom Views option under the View Menu. The Custom View option allows you to save viewing, filtering and printing settings as a named "view". When you ask for the view the file displays with all of the options in place.
    Useful if you print out the file with different headers/footers, portrait and landscape versions etc.
    <img src=/S/lightbulb.gif border=0 alt=lightbulb width=15 height=15> Now what I've never tried is to build a Custom view into a template, but wouldn't that be a nifty thing!
    Hey - I've just tested. Yup Custom Views will work with templates. <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    Cheers
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •