links to other sheets

[sashi4565]

Hi
I have on excel sheet with 20+ work sheets each with Different name.
And my first work sheet contains all work sheet names.
I need to write a macro or VB script to get following …….
When I click on the name of the work sheet in the 1st sheet, control should pass to corresponding work sheet.
Please let me know how to get this.
Thanks in Advance.

Sashi

[royUK]

Your post does not comply with Rule 10 of our Forum RULES. Please acknowledge the response you receive, good or bad. If your problem is solved, please say so clearly.

Thread Title edited this time

[royUK]

take a look at the suggestions here, see navigating a large workbook

http://excel-it.com/vba_examples.htm

[sashi4565]

Hi
Thanks for your quick reply....
Its working,.,,

Sashi

[royUK]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save