Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Change Footer in Normal Template (2000)

    I got this email from a co-worker - have no clue what to tell her. She apparently wants to change her normal template to include a footer - which she managed to do, it says here. Can this be done?

    Thanks





    Hi there!

    Thanks to you I was able to change in Excel the "new" book to the font and pitch I want.

    I was not, however, able to update the template to show a footer so that when I name the book, it adds it to the footer.

    Instructions from Microsoft to change the normal template are as follows:

    Cocuments and Settingsuser nameApplication DataMicrosoftTemplates.

    I opened the normal.xlt sheet, made the footer update and saved. However, when I open by hitting Control and N, it does not show the footer.

    When you have time, can you look into this for me?

    Thanks!!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Change Footer in Normal Template (2000)

    Excel does not use a Normal.xlt as default workbook template. I think your co-worker is confusing Excel with Word, where Normal.dot is the default document template. The file should be named Book.xlt, and a copy should be named Sheet.xlt, and both should be stored in

    Cocuments and Settingsuser nameApplication DataMicrosoftExcelXLSTART

    instead of in the Templates folder. The names Book.xlt and Sheet.xlt are obligatory.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Change Footer in Normal Template (2000)

    Thank you - again.

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Change Footer in Normal Template (2000)

    There are a couple of things. First, as Hans said, if she is creating the new workbook by just opening Excel, then what he said applies. If, as your messages seems to imply, she is creating the workbook by hitting Ctrl+N and then selecting a template named Normal.xlt from the template folder, then she is already doing it correctly.

    However, she can not create the footer in the template that puts the workbook name into the footer since the workbook is not named when the footer is created from the template. Therefore, what gets put into the footer is the blank workbook name. To do what she is asking would require VBA code in the Workbook BeforeSave event routine that put the workbook name into the footer.

    One other problem may be how she is opening and saving the Normal.xlt template. She has to open the template as a template (not as a new workbook as described in her note to you), and then save it as a template (.xlt) back into the template directory.
    Legare Coleman

  5. #5
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Change Footer in Normal Template (2000)

    <hr>creating the workbook by hitting Ctrl+N and then selecting a template named Normal.xlt from the template folder<hr>
    The funny thing is, when one selects File, New, one is presented with a list of templates to select from (in XP and 2003 in the task pane, earlier versions show a dialog). But when one hits control-n (as the menu shows as being the shortcut!!!), one gets a copy of the Book.xlt template if one is there.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  6. #6
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Change Footer in Normal Template (2000)

    Thanks for the reply - she emailed me she believes whatever she did is working for her so - that's it for all of us! Again, thanks.

    Aunt Linda

Posting Permissions

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