I haven't test it, but something like

Dim lnk as Hyperlink
for each lnk in Activesheet.Hyperlinks
activesheet.parent.FollowHyperlink _
address:=lnk.Address, _
subaddress:=lnk.Subaddress, _
NewWindow:=True
Next

might get you started.

--
Regards,
Tom Ogilvy


"Dorian" wrote:


I'm not an excel expert and there may be a better way to activate more
than one hyperlink on a worksheet. I was able to find a macro to delete
all active hyperlinks, leaving just the plain text behind. But what I
need is a macro that can *activate multiple links*.

Does anyone know where I can find one?

THanks,
Dorian



--
Dorian
------------------------------------------------------------------------
Dorian's Profile: http://www.excelforum.com/member.php...o&userid=33231
View this thread: http://www.excelforum.com/showthread...hreadid=530500