add data to combo box in excel then invoke macro

[Richard]

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?

 

[Norman Jones]

Hi Richard,

see David McRitcghie's Build Table of Contents page at:

http://www.mvps.org/dmcritchie/excel/buildtoc.htm