Hi there,

I have a list of published reports in a worksheet, some of which have hyperlinks to their location in Clarity (browser based project management system) and some of which have empty hyperlinks (with a given title)

I also have some code that generates and sends an email from lotus notes.

what I need to do is create some code that will allow users to click on a hyperlink titled "CPO Reports" in column C (there are many instances of the same empty link) and then a message box will appear with a 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 code when they are clicked, but I want to do this with the existing hypelinks instead.

thank in advance,
Matt