Make Excel open some hyperlinks with non-default browser

Short answer, no. Excel has no option to open an url with another program than specified by the system as default.

Excel will threat an url by simply doing: Start url (aka using DDE extension to open the url with whatever is set as default program).

Using a VB Macro, you can however create a custom link that'll launch the link with IE.

It will require a bit of programming and is not easy, and you may have to edit all cells and remove the hyperlink and save the link as text alone in that box for it to work properly.

Although SuperUser is not a scripting site (and a new question specifically for programming should be asked at StackOverflow if you're going to do it that way), you'd be trying to do it as follows.

Launch a macro everytime any cell is clicked (function Sheet1_clicked()) I believe is the event. Then break out of the function if the column is not the column you have your urls in, or alternatively, if the cell does not start with #URL:. You can even check if the next column has this value, so you can effectively hide that column, and make the column before it the event clicking one. You can use a conditional forward to check if the next cell has any text, and if so using colors, show a "click me" text.

Now, in the script itself, you'd program to launch IExplore.exe with the url.


The best way I have found to do this is by creating a link to a Batch File... to create a Batch file, create a text document by RIGHT Click on the desktop or in a folder you want to store the link in, and select >New >Text Document.

Rename the document to something you will remember like Yahoo_Mail.BAT (file name extensions must be turned on or you wont be able to change the extension)

Now right click on the newly created Yahoo_Mail.BAT and choose Edit

To start in Chrome, type: START CHROME.EXE mail.yahoo.com

Now, In Excel, Create your link to point to that file, and it will open the web page, just as if you entered it into a dos command line window. Just remember, if you email someone the Excel document, you must give them the batch file and thell them what folder to put it in on their laptop so the link will work...I use this mostly for personal excel files that I am not emailing to people, but either way it is an easier way that avoids having to program it into excel. If you want to use Explorer, just substitute your browser executable in the above examble (use iexplore.exe for internet explorer) GOOD LUCK! I hope this helps somebody, it really messed with me for a while. I thought I should be able to run the command from the hyperlink tab in excel, that just uses the default browser...

Sometimes, you just want to use another browser to open your links...LOL! I like to use chrome myself for some things, but don't want my main home PC using chrome as a default because of other stuff I do.