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.
Bookmarks