+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Automating Header/Footer Formatting

  1. #1
    Registered User
    Join Date
    04-13-2012
    Location
    Herndon, VA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Automating Header/Footer Formatting

    I produce a report every month which consists of about 15 separate Excel workbooks, each containing between 6-10 worksheets each.

    The formatting of these workbooks as far as page orientation changes from worksheet to worksheet. Some are portrait 8.5 x 11 some are 11x17 landscape. There is a special header and footer that, for a reason I cannot explain, MUST be entered after all of the worksheets have been populated with datat and formatted. Adding the special header and footer information on every worksheet MUST be done as the very last step.

    Unfortunately, if you "Select All Sheets" and add the headers and footers at the very end ... all of the page orientations of all the workbook worksheets change and all the worksheet formatting is lost. Grouping or selecting all the worksheets in order to add the special header footer to ALL the worksheets in the workbooks seems to make Excel choose to change the workbook formatting to be the same for ALL worksheets -- yes, the special header/footer is added...but the formatting of the entire workbook is now screwed up.

    Is there any way to automate adding header/footer data for multiple worksheets without affecting the formatting of all of them in a wookbook?

    Thanks

    (Been doing this for 18 months. Just though "hey...maybe an Excel users group might have the answer.)

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,803

    Re: Automating Header/Footer Formatting

    have you tried to record a macto when you do it? the 1st time round, it will still be a "manual" change, but after that, you can use the nacro to to all the work for you?

    If you try this approach, make sure you do it carfully and accurately...if you are in learn/record mode, everything you do gets recorded
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1