Hyperlinking cells and macros

[Ed Dingman]

Morning all,

I have been working on this for a few days and I am stumped..

I have a worksheet and I am trying (somewhat unsucessfully thus far) to have
cells hyperlink in the same column that have 2 different values I do have
the macro that will hyperlink the individual cells as well as hyperlink the
whole column but there are rows that seperate the circuits so I do not want
ALL the cells hyperlinked..

I have also tried to create a new column and have them alternate values but
it seems when I delete information from the cells that it does not pertain
the hyperlink (though not the text) is removed from the whole column (also
not what I want)


this is what I have so far.

these are for the indivdual cells


Sub Macro14()
'
' Macro14 Macro
' Macro recorded 1/30/2008 by edingman
'
' Keyboard Shortcut: Ctrl+o
'
ActiveCell.Offset(0, 0).Range("A1").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
"\\Nss1\chevrones\30553-Crude-2\CADFILES\2CU.pdf", TextToDisplay:= _
"NO. 2 CRUDE"
End Sub


Sub Macro15()
'
' Macro15 Macro
' Macro recorded 1/30/2008 by edingman
'
' Keyboard Shortcut: Ctrl+e
'
ActiveCell.Offset(0, 0).Range("A1").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
"\\Nss1\chevrones\30553-Crude-2\CADFILES\2RS.pdf", TextToDisplay:= _
"#2 RESID STRIPPER"
End Sub


These are for the whole column


Sub HYPERLINK()

Range("H3:H300").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
"\\Nss1\chevrones\30553-Crude-2\CADFILES\2CU.pdf",
TextToDisplay:= _
"NO 2 CRUDE"



End Sub





Sub HYPERLINK2()

Range("G3:G300").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
"\\Nss1\chevrones\30553-Crude-2\CADFILES\2RS.pdf",
TextToDisplay:= _
"#2 RESID STRIPPER"



End Sub


I an Brand new to macros and VBE in Excel and need help

what I am looking for is this: Is there a way to automaticaly hyperlink
cells as soon as text is added? Is there a way to link to 2 different files
within the same column? if not is there a way to keep the hyperlink behind
the text when I delete the non pertnant text from the other column?

Thank you for any help you can offer in this matter..

 

[Jim Cone]

Deleting non-hyperlinked cells should not affect hyperlinks cells.
Hard to tell what is going on. Have you tried using the Hyperlink function instead?.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins - Free trial of "List Files" - create hyperlinks to files on your drive)



"Ed Dingman"
wrote in message
Morning all,
I have been working on this for a few days and I am stumped..

I have a worksheet and I am trying (somewhat unsucessfully thus far) to have
cells hyperlink in the same column that have 2 different values I do have
the macro that will hyperlink the individual cells as well as hyperlink the
whole column but there are rows that seperate the circuits so I do not want
ALL the cells hyperlinked..

I have also tried to create a new column and have them alternate values but
it seems when I delete information from the cells that it does not pertain
the hyperlink (though not the text) is removed from the whole column (also
not what I want)

this is what I have so far.
-snip-
I an Brand new to macros and VBE in Excel and need help
what I am looking for is this: Is there a way to automaticaly hyperlink
cells as soon as text is added? Is there a way to link to 2 different files
within the same column? if not is there a way to keep the hyperlink behind
the text when I delete the non pertnant text from the other column?

Thank you for any help you can offer in this matter..

 

[Ed Dingman]

I have tried to individually hyperlink the cells individualy and that works
great, however I am looking for a way to hyperlink cells that have 2 seperate
values in them to their respective PDF file. I have managed to modify a
macro I found to do what I want however I want it to be done automatically
(as in the 101 excell hacks lesson 92 talking about getting around the 3
criteria limit for conditional formatting.) That is a private macro (not
sure what that means) that somewhat does what I want it to. the only thing I
need now is to come up uith a way to put the 2 together and have it run.