Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Sep 2002
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Built-in Footers (Excel 2000 / SR-1)

    Is there a way to create and save my own format of a built-in footer ?

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    268
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Built-in Footers (Excel 2000 / SR-1)

    It depends on what you mean by 'your own format.' The simplest way to do it is to simply set up the footer you want in the default sheet and workbook, if you like a particular style that involves the 'standard' excel file information like sheet name, path, number of pages, etc or standard text like a company or department name. To do this, open a new workbook, and create the footer you want - it will work best if you only have one sheet in the workbook. Save the file in the "XLStart" directory as a template named "book.xlt." The Excel Start directory is usually at <font color=blue>C:Program FilesMircrosoft OfficeOfficeXLStart</font color=blue> but the exact location might be different for you. Save the same file (this time it has to have only one sheet in it) as a template called "sheet.xlt" - also in the start directory.

    Each time you start Excel it will load the "book.xlt" template as a new file, and each time you add a sheet to an active workbook it will add the "sheet.xlt" template as a new sheet. Since they already have the footer formatting you want, you can just continue with your work without having to re-set the footers. If you decide you want to change footer settings, just edit them in the Book and Sheet templates, and then save them again. Make sure that they save as "Book" and "Sheet" (.xlt) not "Book1" etc.

    If you are trying to do more complex footers that extract information from the workbook you will have to set them up for each workbook - I posted an <!post=example,173344>example<!/post> a little while ago, and there are other comments in that thread that may be helpful as well. If you do a search on "Footer" you will see posts with more information than one person could possibly use!

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

    Re: Built-in Footers (Excel 2000 / SR-1)

    See if This Thread will get you started on what you want to do. If not, can you tell us what "my own format of a built-in footer" means?
    Legare Coleman

  4. #4
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Tampico, Tamps, Mexico
    Posts
    118
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Built-in Footers (Excel 2000 / SR-1)

    This it is an example:

    Private Sub Workbook_BeforePrint(Cancel As Boolean)
    myPath = ActiveWorkbook.Path
    myName = ActiveWorkbook.Name
    myFullName = myPath & "" & myName
    For Each Sheet In Sheets
    Sheet.PageSetup.CenterFooter = myFullName
    Next Sheet
    End Sub

    additionally, you can indicate font and size...

    Sheet.PageSetup.CenterFooter = "&""Times New Roman,Regular""&8" & myFullName

Posting Permissions

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