If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Footer
Trying for each worksheet to be numbered independently inside of the multipy
chapter workbook. For example; wkst #1 pages 1-3; wkst #2 pages 1-3 etc... It's autonumbering 1-5 instead |
#2
|
|||
|
|||
Footer
Print one worksheet at a time.
If you print multiple sheets, Excel treats as one print job and numbers as pages 1 through whatever. Gord Dibben MS Excel MVP On Tue, 16 Jun 2009 13:34:01 -0700, Sarah wrote: Trying for each worksheet to be numbered independently inside of the multipy chapter workbook. For example; wkst #1 pages 1-3; wkst #2 pages 1-3 etc... It's autonumbering 1-5 instead |
#3
|
|||
|
|||
Footer
Hello Gord;
I appreciate your assistance. Unfortunately, it is such a big workbook. Is there any other way to set a formula or something to acheive the same outcome? Thanks for responding, Sarah "Sarah" wrote: Trying for each worksheet to be numbered independently inside of the multipy chapter workbook. For example; wkst #1 pages 1-3; wkst #2 pages 1-3 etc... It's autonumbering 1-5 instead |
#4
|
|||
|
|||
Footer
You could use a macro to print all sheets would still be separate print
jobs. At least you wouldn't have to manually select each sheet. Private Sub Workbook_BeforePrint(Cancel As Boolean) Dim wkSht As Worksheet For Each wkSht In ThisWorkbook.Worksheets wkSht.PageSetup.RightFooter = "Page &P of &N" wkSht.PrintOut Next wkSht End Sub First make a backup of your workbook in case things go wrong. With your workbook open hit Alt + F11 to open VBEditor. Select your workbook and expand. Double-click on Thisworkbook module. Copy/paste the code above into that module. Alt + q to return to Excel. Save workbook then print workbook. Gord On Wed, 17 Jun 2009 07:02:11 -0700, Sarah wrote: Hello Gord; I appreciate your assistance. Unfortunately, it is such a big workbook. Is there any other way to set a formula or something to acheive the same outcome? Thanks for responding, Sarah "Sarah" wrote: Trying for each worksheet to be numbered independently inside of the multipy chapter workbook. For example; wkst #1 pages 1-3; wkst #2 pages 1-3 etc... It's autonumbering 1-5 instead |
Thread Tools | |
Display Modes | |
|
|