Perfect. This worked just as I had hoped.

Can I add a little bit of complexity? If the destination
sheet is password protected, is there a way to unprotect
it with a password on the originating sheet?

Ex. A user would have to enter a user name and a password
on the starting (originating) sheet and the password would
be incorporated into the macro to unprotect the
destination sheet.

Thanks
-----Original Message-----
One way:

Public Sub Button1_Click()
On Error Resume Next
Worksheets(Range("A1").Text).Activate
On Error GoTo 0
End Sub


In article ,
"Eric" wrote:

I am trying to write a macro that will go to a specific
sheet with the same name as the value of a cell.

Ex. I have a cell that holds a drop down list with
users
names. I would like to select a user, say "eric", hit
a
botton that will take me to a sheet called "eric".

Thanks
.