Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Running code by clicking on a hyperlink cell
Hi there, I have a list of published reports in a worksheet, some of which hav hyperlinks to their location in Clarity (browser based projec management system) and some of which have empty hyperlinks (with given title) I also have some code that generates and sends an email from lotu notes. what I need to do is create some code that will allow users to click o a hyperlink titled "CPO Reports" in column C (there are many instance of the same empty link) and then a message box will appear with yes/no button. If they click yes then the email code will run. any suggestions? I can create command buttons on each line that will activate the cod when they are clicked, but I want to do this with the existin hypelinks instead. thank in advance, Mat -- matp ----------------------------------------------------------------------- matpj's Profile: http://www.excelforum.com/member.php...fo&userid=2107 View this thread: http://www.excelforum.com/showthread.php?threadid=52752 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Suppress hyperlink Dialogue box when clicking on Link | Excel Discussion (Misc queries) | |||
hyperlink - clicking on hyper link to select cell in another sheet | Excel Worksheet Functions | |||
Clicking hyperlink causes toolbar to show | Excel Discussion (Misc queries) | |||
Eliminate second browse box when right clicking for hyperlink | Excel Worksheet Functions | |||
Code for making a cell chage color by dbl clicking, with either a | Excel Programming |