See my answer to our first post.

--
Regards,
Tom Ogilvy

"Chance224" wrote in message
...
I can use the following formula to activate a sheet. Is there a way to
link
it to a msg box instead of a cell?
Sub GoToIt()
Dim s As String
s = Range("A1") 'sheet name To search In
Sheets(s).Activate

End Sub

Thanks,
Chance

"Chance224" wrote:

I have a work book for payroll that has a sheet for each employee. Is
there a
way to write a macro that will search and select a sheet. If possible I
would like to be able to que the macro with a short cut such as Ctrl+s.
I
know you can select a sheet and do Ctrl+F, but I have a summary page
that is
linked to each employee sheet and it seraches through that sheet first.

Thanks,
Chance