Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Posts
    304
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Saving custom headers in drop down list (Excel 2000 SR1)

    I have a user who would like to save some of his custom headers that he uses often in the Header drop down list. Is there a way to do this? There seems like there would be, because there are a few in there that look like they were from the last user on that machine. Thanks for the help!

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Saving custom headers in drop down list (Excel 2000 SR1)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> Satiria

    Could you tell me what headers you are referring to? Are you, by chance, referring to the Header and Footer of the Worksheet, or the Headers of the Columns?

    If you mean the Header and Footer of the Worksheet then the best way to make that happen, is to use VBA and write a procedure that does all the Page Setup work you need.

    This way, you don't even need to bother with the Header/Footer dialog.

    If you need any help, let me know, I am free these days.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

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

    Re: Saving custom headers in drop down list (Excel 2000 SR1)

    If he saves the worksheet he has setup these headers in as Sheet.xlt (file with just this sheet, filetype template) in his XLSTART directory, every new sheet will have these headers available. To achieve the same for every new workbook, save the same sheet as book.xlt in the xlstart dir.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  4. #4
    3 Star Lounger
    Join Date
    Apr 2001
    Posts
    304
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Saving custom headers in drop down list (Excel 2000 SR1)

    Satiria again - tried saving as sheet.xlt and book.xlt but it didn't work. It's very possible that I am doing it incorrectly. So let me revisit what this user wants.

    Under File | Page Setup | Header/Footer tab you've got a drop down list for some preset Headers and Footers. He would like to add 3-4 options to that drop down list, so that at any given time he can select one of those 3-4 options from the drop down list instead of having to create a custom Header when printing. Apparently he has a large spreadsheet that he prints in sections, and he likes each section to have it's own header information. Having to create a custom Header for each section is tiresome, so this is his attempt to automate the process.

    When I added a custom header and saved to he XLSTART dir. as Sheet.xlt, I didn't notice any change in a new workbook. When I did the same and saved as Book.xlt, then every new workbook had that same custom header. So the problem still remains - how to customize the Header drop down menu to include some custom Header options. I'm starting to think Macros are the way to go.

  5. #5
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    199
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Re: Saving custom headers in drop down list (Excel 2000 SR1)

    Satiria,

    I think the only way to get the options your user wants is, as Wassim suggests, via VBA, where a macro could be run which provides a choice for setting the headings to the required options.

    The optional built in heading variations you refer to appear to be just variations of existing information in the spreadsheet - I stand to be corrected but have never seen a way that these can be permanently supplemented or varied, other than by ignoring them and inserting what you want.

    The use of Sheet.xlt and Book.xlt will only provide 1 addition to the built in information, and that can only be varied but the fiddling about that is a problem for your user.

    Good Luck

    Peter Moran
    Two heads are always better than one!

Posting Permissions

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