linking worksheets

[Graham7979]

I have an excel workbook with approx 30 worksheets, i want to create a menu
page wherby a cell (with the name of the worksheet in it) can be clicked on
and this will take me direct to that work sheet, how do i do this ?

[Ardus Petus]

I have home-made XLA that should help: http://cjoint.com/?fwqZQdNgus
It is not protected: you can view & edit the code and the userform

To have tabs alpha ordered, right click on arrows left of tabs list, and
select "Sort tabs"

To select a sheet:
Right-click on a cell and select "Select sheet"
You can type the beginning of the name: it will select corresponding entry
of the list.
To validate: press Enter or double-click on a name
To cancel: press Escape

HTH
--
AP

"Graham7979" <[email protected]> a écrit dans le message
de news: [email protected]...
>I have an excel workbook with approx 30 worksheets, i want to create a menu
> page wherby a cell (with the name of the worksheet in it) can be clicked
> on
> and this will take me direct to that work sheet, how do i do this ?

[KellTainer]

Hi, You could try this solution.

If I understand correctly, you want to be able to select cells which will then link to the sheet of the same name within the same workbook. Well, if you put this code in your sheet object which contains the menu in VBA, everytime you select a cell, it will go to the sheet of the same name. Since its in the menu sheet object, the selection change event wont affect the other objects.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
For Counter = 1 To Application.Sheets.Count
If Application.ActiveCell.Value = Application.Sheets(Counter).Name Then
Application.Sheets(Counter).Select
Exit For
End If
Next Counter
End Sub

Kudos!

[Ragdyer]

Are you aware of the fact that XL has a resident (built in) table of
contents?

Right click on those small arrows to the left of the sheet tabs.
This displays a list of the first 15 tabs, plus it's expandable to an
infinite scrolling list of all the sheets, where a 'double click' of a sheet
name will place you in that sheet.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Graham7979" <[email protected]> wrote in message
news:[email protected]...
> I have an excel workbook with approx 30 worksheets, i want to create a
menu
> page wherby a cell (with the name of the worksheet in it) can be clicked
on
> and this will take me direct to that work sheet, how do i do this ?

[Ken G.]

Bastien Mensink's ASAP Utililities will do this with a couple of clicks. Its
a free add-in which contains about 300 usefull utilities. Go to
www.asap-utilities.com

"Graham7979" wrote:

> I have an excel workbook with approx 30 worksheets, i want to create a menu
> page wherby a cell (with the name of the worksheet in it) can be clicked on
> and this will take me direct to that work sheet, how do i do this ?