Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
simply lost on hyperlinks
from earlier post still trying to figure a hyperlink called from a
command button where i dont have to have cell displaying the hyperlink url, which is bogus anyway because the hyperlink url is being changed programatically anyway the basics of what i'm using this was generously suggested keepIt Cool, still there keepIt? Sub ff() Dim r As Range Set r = [b3] r.Hyperlinks.Add r, "", r.Address,"ClickMe" End Sub here is what i'm trying Private Sub CommandButton3_Click() Dim r As Range Set r = [o18] r.Hyperlinks.Add r, "", ivGraphUrl, "" ' ivGraphUrl is a public var that i set activeworksheet.followhyperlink r end sub so the code works in that i get the web page in a new window but i still get the hyperlink showing in cell 'o18' and not sure why? and while on the subject..... no sure about the r.hyperlinks.add syntax my object browser has this object.Add(Anchor, Address, SubAddress, ScreenTip, TextToDisplay) it seems to be saying add a hyperlink to cell 018 twice, once in the 'r.' and secondly the first parameter 'r' ????? and i'm really using the sub address instead of the address, they are interchangeable?? it seems the worksheet has an array of hyperlinks but i'm not adding the hl to the sheet array directly but to a cell, there is someway to tell what member of the hl array is for each cell?? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lost hyperlinks Excell 2003-HELP | Excel Discussion (Misc queries) | |||
Hyperlinks were lost | Excel Discussion (Misc queries) | |||
filtering simply | New Users to Excel | |||
Simply Accounting | Excel Discussion (Misc queries) | |||
can this be done simply ? | Excel Discussion (Misc queries) |