funkadelic
05-05-2009, 10:19 PM
hey guys,
im working on a spreadsheet where we hyperlink the files into this one spreadsheet.
the idea behind the vba code is as follows
one column is the =hyperlink("directory","Click Here")
next column is the activex checkbox
the vba code right now checks column with checkbox for instances of ticked checkbox (which is linked to the cell in which is positioned to hold the value when its ticked)
then it checks if the column with the hyperlink "hasformula"
if it does then it removes the characters up to the first "
then it removes everything from the second "
then it sends out the file in an email
now
there are a lot of people using this document who would rather hyperlink it by right clicking on the name of the document and putting in a hyperlink, because its easier than typing out a formula and searching for location.
it ruins my method because now there is no formula in the cell, so i cant do what i was doing before. when i hover my mouse over the hyperlink it shows me the location. is there anyway to get that location from that way of hyperlinking. if so would you be so kind to tell me how
thank you
im working on a spreadsheet where we hyperlink the files into this one spreadsheet.
the idea behind the vba code is as follows
one column is the =hyperlink("directory","Click Here")
next column is the activex checkbox
the vba code right now checks column with checkbox for instances of ticked checkbox (which is linked to the cell in which is positioned to hold the value when its ticked)
then it checks if the column with the hyperlink "hasformula"
if it does then it removes the characters up to the first "
then it removes everything from the second "
then it sends out the file in an email
now
there are a lot of people using this document who would rather hyperlink it by right clicking on the name of the document and putting in a hyperlink, because its easier than typing out a formula and searching for location.
it ruins my method because now there is no formula in the cell, so i cant do what i was doing before. when i hover my mouse over the hyperlink it shows me the location. is there anyway to get that location from that way of hyperlinking. if so would you be so kind to tell me how
thank you