+ Reply to Thread
Results 1 to 2 of 2

How to apply current sheet headers/footers to all other sheets?

  1. #1
    Registered User
    Join Date
    07-21-2010
    Location
    Bakersfield, CA
    MS-Off Ver
    Excel 2007
    Posts
    18

    How to apply current sheet headers/footers to all other sheets?

    I am looking for a way to take the current sheet's headers and footers and apply them to all other sheets. Simply selecting all the sheets I want does not work because it applies ALL page setup settings to all the sheets, including print area, margins, and so forth.

    I want only the header and footer to apply to all sheets. I had an idea as follows:

    Please Login or Register  to view this content.

    There are obvious things wrong with this code, but I don't know how to get around it. Any help on how to solve this problem is greatly appreciated!
    Last edited by ericsastud; 04-12-2011 at 06:19 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2003
    Location
    British Columbia , Canada
    MS-Off Ver
    03,07,10,13
    Posts
    727

    Re: How to apply current sheet headers/footers to all other sheets?

    ASSUMPTION:
    In this demo I used Sheet1 as the source of the header/footer setting ... to change source sheet change Set Setup = Worksheets("Sheet1").PageSetup ... ok ?


    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)

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