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