+ Reply to Thread
Results 1 to 2 of 2

Excel Hyperlink Macro Problem

  1. #1
    Registered User
    Join Date
    12-08-2015
    Location
    Cincinnati
    MS-Off Ver
    2010
    Posts
    16

    Excel Hyperlink Macro Problem

    I am very new to marcos and am having trouble.

    As part of a macro I was working on, I wanted to open the hyperlink of a selected cell (contains link to another workbook.) I had it all working nicely, I saved it and closed it. When I reopened it the hyperlink macro will not work right.

    When I run the macro it gives me the usual warning to make sure the link is from a trustworthy source, and asks if Id like to open the file. I click ok, then the hourglass comes up for a few seconds and then it goes away. Nothing happens though, the file does not open.

    But, If I click the actual cell that contains the hyperlink, it gives me the warning, I click ok, and then the file opens. Its frustrating that it worked before I saved and closed it.

    I even made a new file and just set up the hyperlink macro part, but it still will not work. Am I missing something? Thanks for any help.

    Sub Macro1()
    '
    ' Macro1 Macro
    Range("B7").Select
    Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
    End Sub

  2. #2
    Registered User
    Join Date
    12-08-2015
    Location
    Cincinnati
    MS-Off Ver
    2010
    Posts
    16

    Re: Excel Hyperlink Macro Problem

    *Update
    I tried the same thing on another computer and it worked fine. Im thinking its maybe an excel setting, but I am not sure what would be.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Problem with Hyperlink & Macro
    By Crispy85 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-14-2014, 03:56 AM
  2. [SOLVED] Excel 2010 Create a macro to check if cell contains hyperlink then apply hyperlink style
    By chasidar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-12-2013, 04:48 AM
  3. [SOLVED] Problem with hyperlink macro. Works but has a defect.
    By DenisBrochu in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-27-2013, 12:35 PM
  4. VBA Macro created hyperlink problem
    By ew03 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-25-2012, 06:19 PM
  5. Macro problem - stops after the hyperlink is downloaded
    By RBI in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-30-2008, 08:27 PM
  6. Hyperlink problem:my macro's
    By TomBP in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-13-2006, 08:15 AM
  7. Assign Macro / Hyperlink Problem
    By richardreye in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-10-2005, 07:08 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1