navigation between worksheets

[Guest]

1. I have a workbook with 60 named worksheets. It is difficult to scroll back
and forth between them; anybody knows if "go to" or any other trick would
allow to jump to a named worksheet?
2. All these worksheets need to be printed. Is there a way to format them
all (in the same way, as they contain similar data) in one pass?

You canimagine how much I'd appriciate help here, a thought of running Print
Preview-Setup-Header etc is almost unbearable...

 

[Dave O]

1. We use a workbook with many tabs also, and developed a "Jump"
button. On a "Home" page we have a list of tabs; place the cell
pointer on the desired tab and press the Jump button to display the
tab. This requires VBA programming.

2. When you set up the print parameters for the first tab, record it
as a macro. When you're done recording, add the following lines to the
top of the macro:
Dim sName as Variant
For each sName in Sheets
{recorded macro starts}
At the end of the recorded macro, add this line:
Next sName

This creates a loop that visits each sheet in your workbook and applies
the same print parameters. Backup your data before you do this, so you
have a fallback position in case of catastrophic failure.

 

[Guest]

Thank you very much Dave! I'll give it a try right now. Oh, wise words about
backup...

Andrzej

 

[Dave Peterson]

If you're trying to make it easy to navigate through your workbook, you could
make a table of contents worksheet where you could just click on a link to be
taken to a specific worksheet.

You can find some code also at David McRitchie's site:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm

Or you could have a floating toolbar that can show you the names of worksheets
to select:
http://groups.google.com/[email protected]

If you're new to macros, you may want to read David's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm


=======
And lots of print settings (not all) can be set on multiple sheets by grouping
them.

Click on the first worksheet tab
ctrl-click on subsequent (or shift-click to extend)
(or rightclick on any worksheet tab and choose "select all sheets")

Then File|page setup

(Remember to ungroup those sheets when you're done--else anything you change
will be on all those sheets!)

If you're lucky, the settings you want will be the ones you can change!