For a very nice macro solution see this google search thread.
http://snipurl.com/ydgp
Code by Bob Phillips.
Gord Dibben MS Excel MVP
On 7 Oct 2006 02:46:28 -0700, "
wrote:
Hi All,
Is it possible to move to a specific worksheet within Excel given the
sheet's name. This is something like a "Go to Worksheet" functionality.
Thanks,
Sundar
Gord Dibben MS Excel MVP