+ Reply to Thread
Results 1 to 2 of 2

Numbering Pages

  1. #1
    Forum Contributor
    Join Date
    06-21-2006
    MS-Off Ver
    2007
    Posts
    141

    Numbering Pages

    I have a workbook that I am trying to set-up page numbering for programatically. I have a couple of obstacles, the first appears easier to clear than the second.

    First off, not all of the sheets need to be printed each time. So, a checkbox next to each sheet name on a menu may solve that problem. There are only 5-10 sheets. If someone can help me with the language to create the array from the selected sheets, I would appreciate it.

    Second, some of the pages are landscape and some are portrait. All of the pages are put in a report and bound as if they were all portrait, so the location of the page numbers on the landscaped pages needs to be specific. All are on the bottom right hand side of the page.

    I am using Excel 2003. Any help you can give me would be greatly appreciated!

    I have had one person give me a suggestion on a user form. I really need some help with the VBA.

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Numbering Pages

    Here's an earlier post with a userform to select from

    http://www.excelforum.com/excel-prog...tton-only.html

    Are the pages manually set up as Landscape?
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ 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