Hyperlink to my macros in the same workbook


J

Jugglertwo

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
 
Ad

Advertisements

E

Eduardo

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
 
J

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!
 
Ad

Advertisements

E

Eduardo

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top