followhyperlink

  1. R

    Adding query parameter ? to vba FollowHyperlink

    Hi All I did try a search and couldn't easily see that this has been asked already, so here goes... Has anyone tried adding query parameters to a url using FollowHyperlink, and getting a True or False return value depending if the PHP Get script on the page using the parameter validates or...
  2. M

    private sub worksheet_followhyperlink ...

    My code: Private Sub worksheet_followhyperlink(ByVal HL As Hyperlink) Dim linkReq As Object Dim linkStatus As Integer Dim sourceCell As Range Debug.Print HL.Address Application.EnableEvents = False linkStatus = 200 If Dir(HL.Address) = "" Then linkStatus = 404 If linkStatus = 404 Then...
  3. C

    How to make hyperlink "follow" a cell ?

    Hello, I was wondering if it's possible to create a hyperlink in Sheet1, that link it to a specific cell on Sheet2, AND also follow that cell whenever I add/delete rows on Sheet2? My dilemma is that I have a hyperlink created and link it to let's say Sheet2 cell E10. But later on when I add...
  4. H

    Run Macro using shape name when I click on that shape

    Hello all, I have written a macro which "plots" points on a map. Each point is a msoShapeOval, and I add a hyperlink to each shape, so that the tooltip can display the name of the location and the score associated with that location. That's all fine, but I have been asked to add functionality...
  5. S

    open link in existing window/tab

    I thought this would keep all the links in a sheet I'm clicking on in one window/tab but it's not what am I missing? Private Sub Workbook_SheetFollowHyperlink(ByVal Sh As Object, ByVal Target As Hyperlink) ActiveWorkbook.FollowHyperlink Address:=Target.Address, NewWindow:=False End Sub...
  6. T

    Open URL with VBA without Security Message

    Hi all, I've got some code that opens a CSV file via a URL. The problem is that I want to open a large number of these files without a security warning message asking me if I'm really really sure I want to open the CSV file (which I am by the way!). Is there any way to bypass this without...
  7. S

    Named range in Worksheet_FollowHyperlink

    I am using following code Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) MsgBox Target.Range.Text End Sub It works fine, but I can't use named ranges in this function. How is it possible to get following code to work: Private Sub Worksheet_FollowHyperlink(ByVal...
  8. S

    Macro to Open Access File.

    Dear All, I've a Access database named "Abc.accdb", i want to open that database using Macro via Excel VBA. pls assist. Susheel
  9. T

    FollowHyperlink Cancel

    Is there a way to cancel the FollowHyperlink event?
  10. D

    Hyperlinks Cease to Function

    I've always managed to find a solution to my Excel problems on this forum but have found nothing that seems to match the problem I am experiencing with Hyperlinks so just I've registered to raise the problem and see if anyone else has seen it and or has a resolution. I'll try and describe what...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top