+ Reply to Thread
Results 1 to 2 of 2

VBA- Can I change Header after a manual pagebreak?

  1. #1
    Registered User
    Join Date
    06-24-2004
    Posts
    78

    VBA- Can I change Header after a manual pagebreak?

    I am using the code below to insert a pagebreak. but when I change the pagesetup it also changes on the previous pages. Is there a code to not change the headers in previous pages? the only difference in the header is that the previous pages are (detailed) instead of (summary)

    Please Login or Register  to view this content.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello GregJG,

    You could use a print routine to change the header for the "Summary" sheet.
    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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