I'm sure there is a better way but in case no one else responds here is what
I came up with.
You will need to know the cell location of your names. ie. if your command
button caption is set to Independance Day and that title is in cell O25 then
do below:
Add your button, right click the button, left click view code. Where the
cursor is flashing(should be Private Sub Commandbutton_Click()) type:
cells(25,15).select
Now when you click the command button named Independance Day you will taken
to cell O25.

Not the best method but it works.
HTH


"Daniel" wrote in message
...
Hello, I would like to put 100 buttons or so on the top of a sheet and
would like to be able to click on anyone of them so that the action would
be
to go down the same sheet or another sheet directly to where that title
appears. Can someone suggest me a way?

Thanks you

Daniel