LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
page numbering vizhen Excel Discussion (Misc queries) 1 November 13th 06 09:46 PM
Page numbering KC8DCN Excel Discussion (Misc queries) 1 November 8th 06 03:21 AM
Page Numbering Fran Armstrong Excel Discussion (Misc queries) 0 May 26th 06 04:35 PM
Format page numbering to be Page 1 of X Joan at UCSF Excel Discussion (Misc queries) 2 April 6th 06 03:31 AM
Page numbering LookingGood New Users to Excel 1 March 17th 06 12:11 PM


All times are GMT +1. The time now is 12:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"