+ Reply to Thread
Results 1 to 4 of 4

Add footer to all sheets in ActiveWindow.SelectedSheets except for first sheet

  1. #1
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Add footer to all sheets in ActiveWindow.SelectedSheets except for first sheet

    So, basically I am looking to add page numbers to some sheets that are PDFed. I have a macro+function that works just fine, but the problem is that I have a cover as well, that should't get a number. So, Is there a way to add it in all the selected sheets using ActiveWindow.SelectedSheets except for the first sheet?
    Please Login or Register  to view this content.
    Click the * to say thanks.

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: Add footer to all sheets in ActiveWindow.SelectedSheets except for first sheet

    How about
    Please Login or Register  to view this content.

  3. #3
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: Add footer to all sheets in ActiveWindow.SelectedSheets except for first sheet

    Works as expected. Many thanks Fluff, you the man!

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: Add footer to all sheets in ActiveWindow.SelectedSheets except for first sheet

    Glad to help & thanks for the feedback

+ 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. ActiveWindow.View with Chart Sheet
    By bsamuels in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-30-2014, 03:25 PM
  2. Replies: 5
    Last Post: 03-19-2012, 06:14 PM
  3. trouble with ActiveWindow.SelectedSheets.PrintPreview
    By ArielZusya in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-23-2010, 12:59 PM
  4. [SOLVED] How to iterate through sheets and set ActiveWindow
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-24-2006, 06:16 PM
  5. [SOLVED] footer for chart sheets
    By maryj in forum Excel General
    Replies: 4
    Last Post: 06-20-2005, 02:05 PM
  6. ActiveWindow.SelectedSheets.PrintOut
    By excel-lent in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-15-2005, 10:48 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