Hi,
What you need is to create a buttom and assign the macro to it, in excel
2007, go to developer, insert, choose the firs option in Form controls, go to
the cell where you want the buttom and draw it, then you are able to move it.
right click on the mouse in the buttom , assign a macro and highlight your
macro

In excel 2003, go to view, forms and then follow the same steps described
above


"Jugglertwo" wrote:

I have read some of the posts but I'm still not clear how to do this. I want
to hyperlink to a macro in the same workbook.
1) I would like to list several hyperlinks on one tab and hyperlink each one
to a different macro.
2) I understand basic macro recording so I can do this.
3) I understand hyperlinking.
4) I'm unclear how to hyperlink to a specific macro.
5) I want to run the hyperlink by selecting the hyperlink.
6) I assume that I have to use VBA.
7) The name of my macro is "ColorsYears" on a spreadsheet called Yearly Eats.
8) The name of the spreadsheet that contains my hyperlinks is called Report.
Any assistance would be greatly appreciated!
Thanks!
Jugglertwo