C Carolinejames New Member Oct 7, 2015 #1 Hi all, I am carolinejames, I new member of this site.I need to know While creating interactive dashboard,how to put formula for rollover hyperlink technique. For Ex:=IFERROR(HYPERLINK(highlightseries(B4)),"6") how it is work. Attachments interactive rollover.xlsx 10.3 KB · Views: 7
Hi all, I am carolinejames, I new member of this site.I need to know While creating interactive dashboard,how to put formula for rollover hyperlink technique. For Ex:=IFERROR(HYPERLINK(highlightseries(B4)),"6") how it is work.
Hui Excel Ninja Staff member Oct 7, 2015 #2 Did you follow the instructions at: http://chandoo.org/wp/2011/07/20/interactive-dashboard-using-hyperlinks/ They are fiddly but do work if followed exactly Check: 1. The Font should be Wingdings 2. The Function must be in a Code Module in VBA 3. The file must be saved as a *.xlsm or *.xlsb file type Or see attached file: Attachments interactive rollover.xlsm 17.7 KB · Views: 6 Last edited: Oct 7, 2015
Did you follow the instructions at: http://chandoo.org/wp/2011/07/20/interactive-dashboard-using-hyperlinks/ They are fiddly but do work if followed exactly Check: 1. The Font should be Wingdings 2. The Function must be in a Code Module in VBA 3. The file must be saved as a *.xlsm or *.xlsb file type Or see attached file: