Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
re-direct hyperlink event to WebBrowser Object in Excel
Hi there
I am trying to build an application based on Excel 2003. What I want to do is have the Hyperlink load in a WebBrowser Obect within a form. At the moment when I click on a hyperlink the default viewer for that item is launched. I would like to be able to disable the Hyperlink Event and redirect it to the Form. I have tried everything I can think of ... FollowHyperlink (Launched ie before any proceedure is carried out) BeforeNavigate (Only available in WebBrowser Object) Hyperlink.Delete (to remove the hyperlink after capturing it on Change) etc etc Thanks in advance for any suggestions |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
re-direct hyperlink event to WebBrowser Object in Excel
Don't use a hyperlink. Put in text and format it to look like a hyperlink.
Use the selectionchange event. Look at the address of the target argument. If it is your "cell", then execute the code to use the WebBrowser Object. If not, do nothing. -- Regards, Tom Ogilvy wrote in message ups.com... Hi there I am trying to build an application based on Excel 2003. What I want to do is have the Hyperlink load in a WebBrowser Obect within a form. At the moment when I click on a hyperlink the default viewer for that item is launched. I would like to be able to disable the Hyperlink Event and redirect it to the Form. I have tried everything I can think of ... FollowHyperlink (Launched ie before any proceedure is carried out) BeforeNavigate (Only available in WebBrowser Object) Hyperlink.Delete (to remove the hyperlink after capturing it on Change) etc etc Thanks in advance for any suggestions |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
re-direct hyperlink event to WebBrowser Object in Excel
Thanks for the reply, unfortunately they have to be Hyperlinks as there
is another function that uses them. The Links are set up using <a href 'http://www..." Name </a so that the name appears not the address. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
re-direct hyperlink event to WebBrowser Object in Excel
Good luck.
-- Regards, Tom Ogilvy "dave.bostock" wrote in message oups.com... Thanks for the reply, unfortunately they have to be Hyperlinks as there is another function that uses them. The Links are set up using <a href 'http://www..." Name </a so that the name appears not the address. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
re-direct hyperlink event to WebBrowser Object in Excel
Thanks I have a feeling I am going to need it.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel hyperlink to object | Excel Discussion (Misc queries) | |||
webbrowser - excel - modifications | Excel Discussion (Misc queries) | |||
Excel Hyperlink to specific Access object | Excel Discussion (Misc queries) | |||
excel object event handling | Excel Programming | |||
Adding a webBrowser object dynamically to a sheet | Excel Programming |