+ Reply to Thread
Results 1 to 1 of 1

VBA for auto-launching Web links

Hybrid View

  1. #1
    Registered User
    Join Date
    06-25-2016
    Location
    New Delhi
    MS-Off Ver
    2007
    Posts
    6

    VBA for auto-launching Web links

    Hi,

    Can anyone please look into this VBA code and help me tweak it a bit in order to accommodate the changed design.

    I have attached 2 files:
    Source List Demo- file already having a working VBA code
    Source List New- file in which I want to edit the VBA code and run it as per new design

    Source List Demo file design:
    The file contains the main worksheet "Launch" which contains a drop-down in cell D3 and on selecting a country, all the web-links stored in the worksheet of that country open in a browser. For example if we select Australia, all web-links in worksheet "Australia" open in a browser.
    There is a separate worksheet available for each and every country and VBA works on this design.

    Source List New file design:
    The main worksheet "Launch" remains the same but instead of web-links being stored in separate worksheets, a single "Summary" worksheet is created.
    This worksheet contains 'Country Names' in first column and web-links in subsequent columns.

    Query:
    Can you please help me tweak the VBA code applied to "Source List Demo" file in a way that it applies to the new design in "Source List New" file. The objective remains the same- "On selecting a country drop-down, the VBA should open all web-links of that country in a browser window." All these web-links are now stored in a single "Summary" sheet.

    Thanks
    Attached Files Attached Files

+ 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. [SOLVED] Update Links = 1, Auto-Continue
    By gord.lawson11 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-27-2011, 04:10 PM
  2. Links (vlookup) do not auto-update
    By marcazo in forum Excel General
    Replies: 2
    Last Post: 09-06-2011, 11:54 AM
  3. VB auto update links
    By alexandruc in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 10-16-2009, 02:28 AM
  4. Userform help with cells links and macro launching
    By pingwin77 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-04-2008, 10:06 AM
  5. Auto enable macros and links
    By rbeck in forum Excel General
    Replies: 1
    Last Post: 07-16-2008, 10:35 AM
  6. Links auto update on some workbooks but not others
    By Tasza in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-24-2005, 09:05 PM
  7. Auto Update Links
    By ajhil2@hotmail.com in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-31-2005, 04:06 AM
  8. Supress Auto Links Message
    By Nick S in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-26-2005, 07:02 AM

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