Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 27th 11, 04:06 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 153
Default Sequencial page numbering of multiple tabs

Hi, I've seen other posts and solutions to be able to have multiple
sheets print out their pages in sequential order (i.e., sheet 1 goes
from page 1 to 10, sheet 2 will print out starting at page 11 through
22, etc.) That's great, but is there a way to simply VIEW the
subsequent sheets' page numbers in sequential order? What I mean is,
if sheet 1 does have 10 pages, when I hit print preview, I can scroll
through pages 1 through 10. When I select sheet 2 (with say 10
pages), I want to be able to click print preview and scroll through
pages 11 through 20. The reason for this is that we save our Excel
workbooks (with multiple tabs) to a document management system
(eDocs), and when you view the workbook there, you can view the
multiple tabs, but I need the pages to be in sequential order, as
described above. Is there a way to do that either via system settings
(i.e., custom footer) or by VBA? Thanks.

Frank

Reply
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
Sequencial FIXED Numbering ev Excel Discussion (Misc queries) 1 January 18th 10 04:26 PM
Sequencial Names On Worksheet Tabs lehigh46 Excel Worksheet Functions 3 January 29th 09 12:52 PM
Page numbering of multiple sheets JHJ Excel Discussion (Misc queries) 1 May 30th 07 04:19 AM
Consecutive Page Numbering with Multiple Worksheets Daria Excel Discussion (Misc queries) 5 October 5th 06 02:08 PM
Page Numbering between tabs Jeff Excel Discussion (Misc queries) 1 March 21st 05 03:47 PM


All times are GMT +1. The time now is 10:49 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017