selecting w/sheet by click on a cell

colleen

Board Regular
Joined
Feb 21, 2002
Messages
61
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.
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
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
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,520
Messages
6,114,101
Members
448,548
Latest member
harryls

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top