Create hyperlink in excel that opens in Chrome
I am trying to create hyperlinks so that when clicked they will open in Chrome, regardless of what the default browser is.
Can anyone please assist with this
Thank You
excel hyperlink deep-linking
add a comment |
I am trying to create hyperlinks so that when clicked they will open in Chrome, regardless of what the default browser is.
Can anyone please assist with this
Thank You
excel hyperlink deep-linking
3
start here: stackoverflow.com/a/5915643/6241235 An event may be more successful than hyperlink. Format event target cell as fake hyperlink.
– QHarr
Nov 14 '18 at 17:10
But would that not only work if the macro is running? Or would that work if someone is just manually using the spreadsheet?
– Mike Hill
Nov 15 '18 at 19:12
The idea is you use a sheet event - selection change for the cell formatted as a fake hyperlink.... that would be the target. Selecting the cell would trigger the event which would run the code to pass the url to chrome or have the url already in the code.
– QHarr
Nov 15 '18 at 19:14
1
Ok, cool, i guess i just didnt understand, probably a little over my technical capabilities, but as long as i know it should work ill look into getting to grips with this technique. Thank you for the help QHarr
– Mike Hill
Nov 16 '18 at 13:37
add a comment |
I am trying to create hyperlinks so that when clicked they will open in Chrome, regardless of what the default browser is.
Can anyone please assist with this
Thank You
excel hyperlink deep-linking
I am trying to create hyperlinks so that when clicked they will open in Chrome, regardless of what the default browser is.
Can anyone please assist with this
Thank You
excel hyperlink deep-linking
excel hyperlink deep-linking
asked Nov 14 '18 at 17:03
Mike HillMike Hill
488
488
3
start here: stackoverflow.com/a/5915643/6241235 An event may be more successful than hyperlink. Format event target cell as fake hyperlink.
– QHarr
Nov 14 '18 at 17:10
But would that not only work if the macro is running? Or would that work if someone is just manually using the spreadsheet?
– Mike Hill
Nov 15 '18 at 19:12
The idea is you use a sheet event - selection change for the cell formatted as a fake hyperlink.... that would be the target. Selecting the cell would trigger the event which would run the code to pass the url to chrome or have the url already in the code.
– QHarr
Nov 15 '18 at 19:14
1
Ok, cool, i guess i just didnt understand, probably a little over my technical capabilities, but as long as i know it should work ill look into getting to grips with this technique. Thank you for the help QHarr
– Mike Hill
Nov 16 '18 at 13:37
add a comment |
3
start here: stackoverflow.com/a/5915643/6241235 An event may be more successful than hyperlink. Format event target cell as fake hyperlink.
– QHarr
Nov 14 '18 at 17:10
But would that not only work if the macro is running? Or would that work if someone is just manually using the spreadsheet?
– Mike Hill
Nov 15 '18 at 19:12
The idea is you use a sheet event - selection change for the cell formatted as a fake hyperlink.... that would be the target. Selecting the cell would trigger the event which would run the code to pass the url to chrome or have the url already in the code.
– QHarr
Nov 15 '18 at 19:14
1
Ok, cool, i guess i just didnt understand, probably a little over my technical capabilities, but as long as i know it should work ill look into getting to grips with this technique. Thank you for the help QHarr
– Mike Hill
Nov 16 '18 at 13:37
3
3
start here: stackoverflow.com/a/5915643/6241235 An event may be more successful than hyperlink. Format event target cell as fake hyperlink.
– QHarr
Nov 14 '18 at 17:10
start here: stackoverflow.com/a/5915643/6241235 An event may be more successful than hyperlink. Format event target cell as fake hyperlink.
– QHarr
Nov 14 '18 at 17:10
But would that not only work if the macro is running? Or would that work if someone is just manually using the spreadsheet?
– Mike Hill
Nov 15 '18 at 19:12
But would that not only work if the macro is running? Or would that work if someone is just manually using the spreadsheet?
– Mike Hill
Nov 15 '18 at 19:12
The idea is you use a sheet event - selection change for the cell formatted as a fake hyperlink.... that would be the target. Selecting the cell would trigger the event which would run the code to pass the url to chrome or have the url already in the code.
– QHarr
Nov 15 '18 at 19:14
The idea is you use a sheet event - selection change for the cell formatted as a fake hyperlink.... that would be the target. Selecting the cell would trigger the event which would run the code to pass the url to chrome or have the url already in the code.
– QHarr
Nov 15 '18 at 19:14
1
1
Ok, cool, i guess i just didnt understand, probably a little over my technical capabilities, but as long as i know it should work ill look into getting to grips with this technique. Thank you for the help QHarr
– Mike Hill
Nov 16 '18 at 13:37
Ok, cool, i guess i just didnt understand, probably a little over my technical capabilities, but as long as i know it should work ill look into getting to grips with this technique. Thank you for the help QHarr
– Mike Hill
Nov 16 '18 at 13:37
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53305346%2fcreate-hyperlink-in-excel-that-opens-in-chrome%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53305346%2fcreate-hyperlink-in-excel-that-opens-in-chrome%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
3
start here: stackoverflow.com/a/5915643/6241235 An event may be more successful than hyperlink. Format event target cell as fake hyperlink.
– QHarr
Nov 14 '18 at 17:10
But would that not only work if the macro is running? Or would that work if someone is just manually using the spreadsheet?
– Mike Hill
Nov 15 '18 at 19:12
The idea is you use a sheet event - selection change for the cell formatted as a fake hyperlink.... that would be the target. Selecting the cell would trigger the event which would run the code to pass the url to chrome or have the url already in the code.
– QHarr
Nov 15 '18 at 19:14
1
Ok, cool, i guess i just didnt understand, probably a little over my technical capabilities, but as long as i know it should work ill look into getting to grips with this technique. Thank you for the help QHarr
– Mike Hill
Nov 16 '18 at 13:37