Footer


S

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
 
Ad

Advertisements

G

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
 
S

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
 
Ad

Advertisements

G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top