View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] myhnews@yahoo.com is offline
external usenet poster
 
Posts: 5
Default Add Page x of x based on sheets.

I have a document with about 40 sheets. Is there a way to have the
Page x of x be displayed on all sheet. But Page 1 should be sheet 1.
Page 2 should be Sheet 2 etc.

Let's go one more step.

Each sheet has 2 pages. Is it possible to have
Sheet 1, Page 1 to display Page 1 of 80
Sheet 1, Page 2 to display Page 2 of 80
Sheet 2, Page 1 to display Page 3 of 80
Sheet 2, Page 2 to display Page 4 of 80
Etc.

Thank you