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...

Some videos you may like

This Week's Hot Topics