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

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

that is a great option but can I get the same result without creating the
button?
I would like to click on the existing text and have the macro executed.
Is this possible?
Thanks!

"Eduardo" wrote:

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

Hi,
The buttom has a text that you can change for yours, and it looks good, I
don't think you can execute a macro from a text. another thing you can do is
to assign a letter that when you hit let's say CTRL A that macro will
excecute but you will have to tell the user in the menu wich lette to press
with the CTRL key in order to get the macro executed

"Jugglertwo" wrote:

that is a great option but can I get the same result without creating the
button?
I would like to click on the existing text and have the macro executed.
Is this possible?
Thanks!

"Eduardo" wrote:

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