Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: selecting w/sheet by click on a cell

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    61
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a work book with a lot of sheets, I wonder is it possible to have the first sheet have the names of all the tabs of each worksheet so all i do is click or press enter of the tab name on the first sheet (a sort of table of content) it will automatically go to that sheet..hmmm thk c.

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Posts
    103
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You need to name cell A1 in each sheet that you have, by the name of the sheet. then in your first sheet type all the names of the sheets in separate cells and on each one, right-click and add Hyperlink. Click on Place In This Documen, and select the cells from the list that you have named. Hope this helps.
    Will

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Perth Australia
    Posts
    1,584
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Colleen
    Try this:

    Right click your sheet tab, left click View Code and paste in this event macro code:

    Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    On Error Resume Next
    Sheets(Target.Value).Select
    End Sub

    Type your sheet names on Sheet1 (or whatever). When you double click the sheet name the macro will select that sheet.

    Hope this helps
    regards
    Derek


  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Perth Australia
    Posts
    1,584
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Colleen
    Try this:

    Right click your sheet tab, left click View Code and paste in this event macro code:

    Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    On Error Resume Next
    Sheets(Target.Value).Select
    End Sub

    Type your sheet names on Sheet1 (or whatever). When you double click the sheet name the macro will select that sheet.

    Hope this helps
    regards
    Derek


  5. #5
    Board Regular
    Join Date
    Feb 2002
    Posts
    61
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    thanks a lot both of u nice guys for that speedy response..works a charm...colleen

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •