Where do you store the name?

Is it in a cell (like A1) of each sheet? Or is it right on the worksheet tab?

If it's on the worksheet tab and you've got to hunt through lots to get to the
one you want, you can right click on the VCR like controls to the left of the
tabs and see a list of all the worksheets in the workbook. (You may have to
click on "more sheets" to see all.)

You could sort the worksheets in alphabetical order to make searching easier:

Chip Pearson's:
http://www.cpearson.com/excel/sortws.htm

David McRitchie's:
http://www.mvps.org/dmcritchie/excel...#sortallsheets

You could make a table of contents worksheet where you could just click on a
link to be taken to a specific worksheet.

You can find some code also at David McRitchie's site:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm

Or you could have a floating toolbar that can show you the names of worksheets
to select:
http://groups.google.com/groups?thre...1C74%40msn.com

If you're new to macros, you may want to read David's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Chance224 wrote:

I have a workbook to track employee's time. There is a sheet for every
employee and then a recap sheet that totals the hours & etc. How can I make
a macro to search for a certin name and then activate that sheet. We have
alot employee's and its a pain to search for the person and enter in the data.

Thanks,
Chance

--

Dave Peterson