View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] pants4ants@gmail.com is offline
external usenet poster
 
Posts: 2
Default Page & Chart Numbering

Howdy-

Here's what I have:

17 tabs in a workbook (8 tabs are worksheets [with single print areas]
and 9 tabs are charts.)

Here's what I seek:

1) a footer macro that will place text on the right- - -on ALL 17
pages (I have not found a macro that will foot my 9 charts in addition
to my 8 spreadsheets. I am beginning to believe that manually footing
each chart is the only way. . . is it?)

2) a footer macro that will number my worksheets AND charts in their
existing tab order 1 thru 17. (The macros I have used have resulted in
numbering each worksheet '1'. Even though this was not my goal, the
macros did nothing to my charts!)

Here's one more question: In page break preview, "page 1" appears on
tab 1in the print area. That seems reasonable. Why does "page 1"
also appear in the print areas of each of my other 7 tabs?

I have learned much from my search for a solution, but now I must
post.

Many thanks for your input.

Don Sacks, Fairfax, VA