Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Cheltenham, Gloucestershire, England
    Posts
    214
    Thanks
    0
    Thanked 0 Times in 0 Posts

    consecutive page numbers for multiple worksheets (2000)

    I have about 23 worksheets which I print all or some at once - I have a macro which after grouping together the requuired sheets set , via an input box, the name of the person preparing the sheets in every footer, together with a page number. Is there any way I can number the worksheets in the footer so that they appear to be all part of the same document (they are not always in the same order or the same number so I cannot do it permanently manually)

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: consecutive page numbers for multiple worksheets (2000)

    When multiple sheets in one WB are selected manually, page numbers are sequential in the order of sheet selection. So we probably need to see your code.
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: consecutive page numbers for multiple workshee

    If you select all of the sheets and print them all with one print commend, then the page number in the footer should be consecutive.
    Legare Coleman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •