Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 -- Dorian ------------------------------------------------------------------------ Dorian's Profile: http://www.excelforum.com/member.php...o&userid=33231 View this thread: http://www.excelforum.com/showthread...hreadid=530500 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hyperlinks and macros | Excel Discussion (Misc queries) | |||
Hyperlinks & macros | Links and Linking in Excel | |||
Hyperlinks & macros | Excel Discussion (Misc queries) | |||
Worksheet with multiple Hyperlinks and Macros | Excel Programming | |||
Activating sheets with same name in multiple workbooks | Excel Programming |