Hi Richard,
see David McRitcghie's Build Table of Contents page at:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm
---
Regards,
Norman
"Richard" wrote in message
...
I want to either add a combo box or using data validation creat a list of
peolpes names. I will create a worksheet with each persons name and use
the
result of the combo box or drop down list t navigate to the corresponding
worksheet.
How can I set this up?