Select from drop down & Go To Worksheet

[hsandeep]

My Excel workbook contains lot of worksheets à Week1 to Week52.
I want to move my cursor in various worksheets i.e. open various worksheets 1 at a time. To achieve this, I need à
1. A ‘link’ or ‘something of that sort’, mouse clicking on which enables the action of, example F GoToWeek21 worksheet is accomplished i.e. worksheet [Week21] tab named is opened now.
2. Further extension of it à A drop down list box required (say, in cell E4) which should contain ALL the worksheet’s tab names in it, out of which I would ‘select’ a worksheet’s tab name & click ‘a button’ with a name on it like ‘Enter’ or ‘OK’ or ‘Go There’ & the action of the selected worksheet getting opened up is accomplished.
3. My workbook is opened & currently I am in [Week1] & I am using Microsoft Office 2007 suite.
Please help.
Sandeep

 

[hsandeep]

Smitty,
Your code will work. But I could not accomplish it the way it should have since the code languages are not at all my cup of tea & neither do I know where & how to add it properly. But I do need this.
I tried by opening a new Excel workbook ‘Book1.xlsm’ with [Sheet1], [Sheet2] & [Sheet3] worksheets in it. Then in Sheet1, pressed [Alt] + [F11] to open VBA editor & in the box opened copied the codes (which I had copied in a text file) & saved & closed the workbook. Reopened this workbook again but all cells were blank in [Sheet1]. Worksheets names did not appear anywhere.
I know I had gone in a wrong direction. Sir, please do guide me.
Sandeep

 

[Smitty]

The code I wrote for you won't add Data Validation, so you'll need to add that on your own. And if you changed the code you should post your end result.