Workbook Navigation (XP)

Topic

New Reply

Hi All,

I have a couple of large workbooks (don’t we all) and I’m getting sick of alt page up and alt page down (not to even mention the silly mouse). SOOOOO, anyone got any hints on useful workbook navigation – macro or otherwise would be useful.

Reply | Quote

Replies

For a LARGE number of sheets, I have found that an INDEX sheet which has hyperlinks to each of the sheets works relatively well.

I had an (inherited) workbook with over 300 sheets that I KNEW how to fix but could not find the time to invest in revamp so I lived with it and made it easier to manipulate. Each sheet had from 2 – 6 crossreferences on the index sheet. Thes hyperlinks were alphabetized by code, Notebook#, product name, etc so from the index you could hyperlink to any sheet. Each sheet had a button to return to the index page.

Since the size of the index sheets can get large, I also grouped them and kept each group to be just 1 screen (no scrolling) and had buttons to go to various letters or other subgrouped “screen” on the index sheet.

Then I hid all the tabs so people did NOT even have to use the tabs at all.

Steve

Reply | Quote

For a LARGE number of sheets, I have found that an INDEX sheet which has hyperlinks to each of the sheets works relatively well.

I had an (inherited) workbook with over 300 sheets that I KNEW how to fix but could not find the time to invest in revamp so I lived with it and made it easier to manipulate. Each sheet had from 2 – 6 crossreferences on the index sheet. Thes hyperlinks were alphabetized by code, Notebook#, product name, etc so from the index you could hyperlink to any sheet. Each sheet had a button to return to the index page.

Since the size of the index sheets can get large, I also grouped them and kept each group to be just 1 screen (no scrolling) and had buttons to go to various letters or other subgrouped “screen” on the index sheet.

Then I hid all the tabs so people did NOT even have to use the tabs at all.

Steve

Reply | Quote

Tim

Since you know what sections, or what worksheets you visit the most, you can write some VBA code to take you there.

Try something like

Sub TakeMeThereCountryRoad()
Application.Goto Reference:=”Sheet2!” & Range(“B12”).Address(ReferenceStyle:=xlR1C1)
End Sub

If you don’t want to use code, try the F5 Goto with a bunch of Named Ranges. But again, this will take time to design the named ranges.

HTH

Wassim

Reply | Quote

Tim

Since you know what sections, or what worksheets you visit the most, you can write some VBA code to take you there.

Try something like

Sub TakeMeThereCountryRoad()
Application.Goto Reference:=”Sheet2!” & Range(“B12”).Address(ReferenceStyle:=xlR1C1)
End Sub

If you don’t want to use code, try the F5 Goto with a bunch of Named Ranges. But again, this will take time to design the named ranges.

HTH

Wassim

Reply | Quote

Try Navigator Utilities (at http://www.robbo.com.au[/url%5D). It has a Sheet Navigator which allows you to easily move between sheets, as well as showing hidden and protected sheets, and lots of other features. Also helps you to navigate around links and named ranges.

regards

Reply | Quote

Try Navigator Utilities (at http://www.robbo.com.au[/url%5D). It has a Sheet Navigator which allows you to easily move between sheets, as well as showing hidden and protected sheets, and lots of other features. Also helps you to navigate around links and named ranges.

regards

Reply | Quote