+ Reply to Thread
Results 1 to 7 of 7

Excluding one sheet from 'add headers'

  1. #1
    Forum Contributor
    Join Date
    02-17-2005
    Location
    Wokingham
    MS-Off Ver
    365
    Posts
    111

    Excluding one sheet from 'add headers'

    Hi

    I have added a work sheet to my spreadsheet that I want to exclude from the following macro that adds info to the headers and footers of all worksheets.

    The new worksheet is called Print PO

    HTML Code: 
    I would be grateful for some advice on how to edit the code to do this.

    Thanks in advance
    Steven811

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,013

    Re: Excluding one sheet from 'add headers'

    Please Login or Register  to view this content.

    Change "whatever" to, well, whatever ...

    Regards
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Contributor
    Join Date
    02-17-2005
    Location
    Wokingham
    MS-Off Ver
    365
    Posts
    111

    Re: Excluding one sheet from 'add headers'

    Thank you very much

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,013

    Re: Excluding one sheet from 'add headers'

    You're welcome.

    If this has answered your question, please mark your thread as solved. See my signature for details or the FAQ.

    Regards

  5. #5
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Excluding one sheet from 'add headers'

    alternative method: (sorry, TMS )

    Please Login or Register  to view this content.



  6. #6
    Forum Contributor
    Join Date
    02-17-2005
    Location
    Wokingham
    MS-Off Ver
    365
    Posts
    111

    Re: Excluding one sheet from 'add headers'

    Hi TMS

    That 2nd posting has floored me, sorry for my lack of understanding.

    I've been working on your first kind reply and I have a compile error "for control variable already in use at"

    "For Each ws In ActiveWorkbook.Worksheets"


    HTML Code: 
    Any thoughts would be much appreciated

    Thanks

    Steven811

  7. #7
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,013

    Re: Excluding one sheet from 'add headers'

    This code seems OK to me:

    Please Login or Register  to view this content.

    Don't mind snb ... he's just showing off :-))

    Regards

+ 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