Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have two cell that are joined via concatenation. Together they
produce a hypertext link. The cell actually displays: "ACTIVATE WWW LINK." The cell actually contains : =HYPERLINK(LOOKUP(H20,'DOWNLOAD-CALC'!FM3:FM27,'DOWNLOAD-CALC'!FN3:FN27)&E16,"ACTIVATE WWW LINK") And the two concatatated cells produce: http://secinfo.com/$/search.asp?find=MTSX The link point-too address's and the stocks ticker symbol constantly change. I want to activate the link using a visual or image object (button). Can you use the assign hypertext link function when you right click a visual object in excel and format the hypertext cell in a manor that connects the two cells referenced componments and functions as a link? Or do I need a VBA macro that activate that cell and thus fetch the requested page in the Safari browser on my computer. The macro recorder will allow me to record the process but does not fetch the page when played back. I would think that all I would need for the VBA macro to do is click or activate the cell? Can't find a way to do that. Tried Activate Cell address. Nothing I have searched several forums for something simular. Became more time effective to ask. Thanks for any suggestions. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Image - Object with an embedded link to a cell | Excel Discussion (Misc queries) | |||
Activate object | Excel Worksheet Functions | |||
Activate Object question | Excel Worksheet Functions | |||
Activate Object question | Excel Worksheet Functions | |||
PASTE LINK option not available when I select PASTE SPECIAL to link an image in Excel to a Word document. | Links and Linking in Excel |