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
|