Footer

[Sarah]

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

 

[Gord Dibben]

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

 

[Sarah]

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

 

[Gord Dibben]

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