workbook page numbering

  • Thread starter Thread starter Jost
  • Start date Start date
J

Jost

My workbook pages are divided into pages---

When printing the entire workbook, I would like to the page numbering start
over for each page in the workbook.

As I print the entire workbook, numbering is 1 of 40, 2 of 40 - etc

I would like 1 of 10 for the first page - 1 of 5 for the second page, etc as
I print the entire workbook.

Can this be done.

Jackie

--
 
You could try a macro:

Sub Print_All
dim wksTemp as sheet

On Error Resume Next
for each wksTemp in sheets
wksTemp.Printout copies:=1
next wkstemp
End Sub
 
Back
Top