1

I have a ms excel 2007 worksheet with a column (A) of hyperlinks using the excel function in this way =HYPERLINK(A2,"url".

How Can I make (if this is possible) open all cels on that column in the NON default browser?

  • Short answer is no you cannot – Raystafarian May 23 '16 at 17:47
1

If you enter the path of the browser with the exe file and put the URL after, it will open using that browser.

For example

"C:\Program Files (x86)\Google\Chrome\Application\chrome.exe" http://superuser.com/questions/1079979/how-can-i-make-an-excel-column-of-hyperlinks-open-in-non-default-browser

Unfortunately you can not use this in Excels Hyperlink function, so we need a workaround.

One solution would be, to create a batch file and set the hyperlink to run that batch file. All you need to do is copy the code into a text file, and save it as .bat


Another solution is using VBA.
Press alt + F11, and paste the following code into "ThisWorkbook".

Private Sub Workbook_SheetFollowHyperlink(ByVal Sh As Object, ByVal Target As Hyperlink)

If Target.Name = "asd" Then 'Or you can identify a cell using it's range instead of its name If Target.Range.Address = "$A$1" Then

Shell ("C:\Program Files (x86)\Google\Chrome\Application\chrome.exe http://superuser.com/questions/1079979/how-can-i-make-an-excel-column-of-hyperlinks-open-in-non-default-browser")
End If

End Sub

Than you have to make a hyperlink out of the cell by right click, hyperlink, select place in this document, than ok.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.