Home |
Search |
Today's Posts |
#1
|
|||
|
|||
navigation between worksheets
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... |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
Thank you very much Dave! I'll give it a try right now. Oh, wise words about
backup... Andrzej "Dave O" wrote: 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. |
#4
|
|||
|
|||
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/groups?thre...1C74%40msn.com 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! Andrzej wrote: 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 Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Web-type Back and Forward navigation between Excel worksheets | Excel Worksheet Functions | |||
Excel needs to have the ability to insert "SUB" worksheets | Excel Worksheet Functions | |||
Define list of worksheets | Excel Worksheet Functions | |||
Merge Worksheets | Excel Worksheet Functions | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) |