Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Apr 2002
    Location
    Pleasant Hill, CA
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Different/no header on page 1 (2002)

    We want to have no header on page 1 and then start the header on page 2 with the word 'continued.' That isn't possible, is it? I can select only one header per tab/worksheet. Thanks for your help!

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Different/no header on page 1 (2002)

    The key is to set the header on page 1 to nothing then print page 1, Then reset the header and then print the remaining pages
    Here is a simple basic idea, you can add other refinements as needed. Change the Center header as desired for the other sheets (or change to Left, right, or even a footer). You could actually print a different header on each sheet if desired.

    Steve

    <pre>Sub PrintSheet()
    With ActiveSheet
    .PageSetup.CenterHeader = ""
    .PrintOut 1, 1
    .PageSetup.CenterHeader = "Center header"
    .PrintOut 2
    End With
    End Sub</pre>


  3. #3
    4 Star Lounger
    Join Date
    May 2002
    Posts
    410
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Different/no header on page 1 (2002)

    Is there a way to add formatting to this?

    I would like to have "'Table #" on the first line and "Table Title" on the second line and the text would be bold, 14 point, and centered

    thanks.

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

    Re: Different/no header on page 1 (2002)

    Look up the subject "Formatting Codes For Headers And Footers" in the Excel VBA help. You can use something like this:
    <code>
    ActiveSheet.PageSetup.CenterHeader = "&14&B Table #" & vbCr & "Table Title"
    </code>
    &14 means font size 14, and &B means Bold. CenterHeader is automatically centered.

  5. #5
    4 Star Lounger
    Join Date
    May 2002
    Posts
    410
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Different/no header on page 1 (2002)

    thank you!

Posting Permissions

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