Need macros for activating multiple hyperlinks
 

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

Does anyone know where I can find one?

THanks,
Dorian
:confused

--
Doria
-----------------------------------------------------------------------
Dorian's Profile: http://www.excelforum.com/member.php...fo&userid=3323
View this thread: http://www.excelforum.com/showthread.php?threadid=53050

Need macros for activating multiple hyperlinks
 

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
:confused:


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

Need macros for activating multiple hyperlinks
 

Anything that doesn't involve programming as I don't have experience
with programing in Excel?

Thanks,
Dorian


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

Need macros for activating multiple hyperlinks
 

We're confused. A macro IS a program. Of course, you can create a macro
using macro recorder, which creates the macro program for you, but I don't
think what you want to do can be done with the macro recorder.

"Dorian" wrote:


Anything that doesn't involve programming as I don't have experience
with programing in Excel?

Thanks,
Dorian


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