Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Insert Footer into Every New Workbook Automatically

  1. #1
    New Member
    Join Date
    May 2002
    Location
    Houston
    Posts
    37
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Forgive me for asking a question that I could have likely found the answer to by searching the previous posts, however, in my defense, I got an odd SQL error when I tried to search.

    I would like excel to automatically insert a footer into each new workbook as soon as I open one. I know this can be done, and it involves the personal.xls and auto run or open, I just am not sure about exactly how to make it work.

    Thanks!

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You can create an empty workbook with the desired footer and save it as Book.xlt into your XLStart folder. See the Excel Help topic for "Customize the defaults for a workbook or worksheet by using a template".

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Sydney/Brisbane , Australia
    Posts
    542
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    The SQL error you are incountering is due to your search being to broad. make sure that if you use multiple words in your search than you check the "search for ALL of the terms".

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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