LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Activate web link via image object

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Image - Object with an embedded link to a cell Julius Excel Discussion (Misc queries) 0 January 18th 08 07:45 PM
Activate object Eva Excel Worksheet Functions 0 December 14th 07 05:47 PM
Activate Object question Eva Excel Worksheet Functions 0 December 14th 07 12:41 AM
Activate Object question Eva Excel Worksheet Functions 0 December 14th 07 12:41 AM
PASTE LINK option not available when I select PASTE SPECIAL to link an image in Excel to a Word document. tln Links and Linking in Excel 0 April 22nd 07 04:28 PM


All times are GMT +1. The time now is 02:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"