LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 49
Default Hyperlink to my macros in the same workbook

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
HYPERLINK VALUES AND REMOVING MACROS Mary-Anne Excel Worksheet Functions 1 February 17th 09 08:23 AM
How do I save a workbook as a new workbook by using macros? KingKarl Excel Discussion (Misc queries) 4 November 10th 05 08:34 AM
Intra-workbook hyperlink: macro/function to return to hyperlink ce marika1981 Excel Discussion (Misc queries) 3 May 6th 05 05:47 AM
How to hyperlink from a workbook to sheets in another workbook? MJOHNSON Excel Worksheet Functions 0 February 17th 05 08:31 PM
Hide hyperlink cell & replace with macros Jose Excel Worksheet Functions 1 February 14th 05 08:23 AM


All times are GMT +1. The time now is 07:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"