PDA

View Full Version : Solved: links



khalid79m
04-08-2008, 07:38 AM
i have over 1000 of these links

http://cssm-web.systemssss.uk.hsbc/Eusssreka!/Repsorst/FrameSet.aspx?id=788200

in row R

I should be able to just double click on this link and it will take me to the desired destination.

Only this does not work I have to select the cell and press enter in the formula bar and then double click the link

why is that ~>?

lucas
04-08-2008, 07:49 AM
Joseph has a kb entry that addresses this problem...click here (http://vbaexpress.com/kb/getarticle.php?kb_id=905).

khalid79m
04-08-2008, 08:00 AM
help? i dont follow

lucas
04-08-2008, 08:20 AM
I don't understand because I only have to click on a link one time and it opens an explorer window......that goes to the linked website.

Can you explain what you are doing different than what shows in the picture?

khalid79m
04-08-2008, 09:40 AM
hi it doesnt bring up the yellow box, until select the cell, go the formula bar and press enter after the last bit and then go back to the cell, when i hover over it the yellow box comes up for me to click to take me to the audio.

help

lucas
04-08-2008, 09:49 AM
post your workbook please. go to post reply at the bottom left of the last post......type your message and then scroll down and look for a button that says "manage attachements."

khalid79m
04-08-2008, 09:57 AM
attachement

lucas
04-08-2008, 10:08 AM
you need to add a forward slash to your URL's

see attached.....I fixed the bottom link in your example

it's always the simplest things......

tpoynton
04-08-2008, 10:49 AM
I think adding the ending forward slash is doing the same thing as double-clicking the cell, or clicking enter in the formula bar. if you add the ending / with a formula, no hyperlinkie.

why does it do it? apparently, the way the sheet is created, the links are created as text and not hyperlinks. finding a way to create the links upon workbook creation would be the simplest way to go.

There is the hyperlink formula that might help reduce clicking or editing the cell...

=hyperlink()

lucas
04-08-2008, 11:33 AM
New one for me tpoynton......didn't know there was a worksheet funtion for hyperlink......

mdmackillop
04-08-2008, 01:19 PM
Sub Macro1()
For Each cel In Intersect(Range("R:R"), ActiveSheet.UsedRange)
ActiveSheet.Hyperlinks.Add Anchor:=cel, Address:=cel.Text
Next
End Sub

khalid79m
04-09-2008, 01:47 AM
cel variable not set what does that mean?

mdmackillop
04-09-2008, 04:08 AM
Sub Macro1()

Dim Cel as range
For Each cel In Intersect(Range("R:R"), ActiveSheet.UsedRange)
ActiveSheet.Hyperlinks.Add Anchor:=cel, Address:=cel.Text
Next
End Sub

khalid79m
04-16-2008, 08:04 AM
thanks that works a treat thanks mdmackillop