+ Reply to Thread
Results 1 to 4 of 4

VBA header for only page two

  1. #1
    Registered User
    Join Date
    02-24-2012
    Location
    florida
    MS-Off Ver
    Excel 2010
    Posts
    97

    VBA header for only page two

    Good day,

    im trying to get a header to appear by a selection , but the header must only appear on page two as page 1 has all my activex button.

    is there a code that can call out a single page?

    i've goggled it and only came up with page one footer different.

    I don't have a sample document as its just a header.


    Thanks

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: VBA header for only page two

    How many pages does your document have?
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Registered User
    Join Date
    02-24-2012
    Location
    florida
    MS-Off Ver
    Excel 2010
    Posts
    97

    Re: VBA header for only page two

    it has 3 pages,

    I have come up with this code but it does all three pages
    Please Login or Register  to view this content.

  4. #4
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: VBA header for only page two

    For what you're trying to do you could add your conditional content to just the second page header as permanent text, then just toggle the 'different odd and even' page layout attribute. For example to add your conditional content to just the second page header as permanent text, you could use code like:
    Please Login or Register  to view this content.
    as a once-off exercise. Then whenever you want to toggle the header's display on/off, you could use code like:
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 7
    Last Post: 04-29-2013, 08:38 PM
  2. insert page header after page break
    By dgkindy in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-17-2009, 10:35 AM
  3. Page Header
    By LS Flowers in forum Excel General
    Replies: 2
    Last Post: 03-05-2009, 03:56 PM
  4. Changing Page Header for each page of Dictionary
    By wali in forum Word Formatting & General
    Replies: 9
    Last Post: 02-09-2009, 01:01 PM
  5. Replies: 2
    Last Post: 01-16-2009, 05:24 PM
  6. Replies: 3
    Last Post: 03-29-2006, 12:50 PM
  7. Page Header
    By jake1729 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-15-2005, 10:28 PM
  8. [SOLVED] header and footer on every page except the first page?
    By marany in forum Excel General
    Replies: 3
    Last Post: 05-05-2005, 06:50 AM

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