Mixing
Excel Hyperlink - Opening a write-reserved document causes excel to freeze
I have an excel spreadsheet containing multiple hyperlinks to other documents (Multiple filetypes, whether it's word, excel, .msg from Outlook, etc.). Most of these documents however, are write-reserved.
The problem is, the popup box that prompts you to open as read only or to type in the password is behind the excel program. Basically, upon clicking a link on the excel, it freezes completely. You'd have to go through ALT TAB, cycling through the open programs until you find Word, for example. Then the popup box will show infront of Excel, allowing me to interact with it.
This is tedious, and if I were to share it to others, downright unusable, as not everyone knows how to use ALT TAB. You can't even minimize excel to find the popup box, since it's completely frozen.
How do you make sure that the popup box shows infront of the excel program? Even better, how do you make it so that it only opens the hyperlinked documents as Read Only? I have attempted to catch the hyperlink event in VBA and try to minimize excel, but excel just immediately freezes.
EDIT: This is not a VBA hyperlink, rather I have all the URLs and converted them to a hyperlinked cell (but still through VBA) since it's more 'convenient' to click on the word itself.
excel vba excel-vba hyperlink
edited Nov 21 '18 at 7:38
Pᴇʜ
21.4k42750
asked Nov 20 '18 at 18:52
BasherBasher
25718
add a comment |
I have an excel spreadsheet containing multiple hyperlinks to other documents (Multiple filetypes, whether it's word, excel, .msg from Outlook, etc.). Most of these documents however, are write-reserved.
The problem is, the popup box that prompts you to open as read only or to type in the password is behind the excel program. Basically, upon clicking a link on the excel, it freezes completely. You'd have to go through ALT TAB, cycling through the open programs until you find Word, for example. Then the popup box will show infront of Excel, allowing me to interact with it.
This is tedious, and if I were to share it to others, downright unusable, as not everyone knows how to use ALT TAB. You can't even minimize excel to find the popup box, since it's completely frozen.
How do you make sure that the popup box shows infront of the excel program? Even better, how do you make it so that it only opens the hyperlinked documents as Read Only? I have attempted to catch the hyperlink event in VBA and try to minimize excel, but excel just immediately freezes.
EDIT: This is not a VBA hyperlink, rather I have all the URLs and converted them to a hyperlinked cell (but still through VBA) since it's more 'convenient' to click on the word itself.
excel vba excel-vba hyperlink
edited Nov 21 '18 at 7:38
Pᴇʜ
21.4k42750
asked Nov 20 '18 at 18:52
BasherBasher
25718
add a comment |
I have an excel spreadsheet containing multiple hyperlinks to other documents (Multiple filetypes, whether it's word, excel, .msg from Outlook, etc.). Most of these documents however, are write-reserved.
The problem is, the popup box that prompts you to open as read only or to type in the password is behind the excel program. Basically, upon clicking a link on the excel, it freezes completely. You'd have to go through ALT TAB, cycling through the open programs until you find Word, for example. Then the popup box will show infront of Excel, allowing me to interact with it.
This is tedious, and if I were to share it to others, downright unusable, as not everyone knows how to use ALT TAB. You can't even minimize excel to find the popup box, since it's completely frozen.
How do you make sure that the popup box shows infront of the excel program? Even better, how do you make it so that it only opens the hyperlinked documents as Read Only? I have attempted to catch the hyperlink event in VBA and try to minimize excel, but excel just immediately freezes.
EDIT: This is not a VBA hyperlink, rather I have all the URLs and converted them to a hyperlinked cell (but still through VBA) since it's more 'convenient' to click on the word itself.
excel vba excel-vba hyperlink
edited Nov 21 '18 at 7:38
Pᴇʜ
21.4k42750
asked Nov 20 '18 at 18:52
BasherBasher
25718
I have an excel spreadsheet containing multiple hyperlinks to other documents (Multiple filetypes, whether it's word, excel, .msg from Outlook, etc.). Most of these documents however, are write-reserved.
The problem is, the popup box that prompts you to open as read only or to type in the password is behind the excel program. Basically, upon clicking a link on the excel, it freezes completely. You'd have to go through ALT TAB, cycling through the open programs until you find Word, for example. Then the popup box will show infront of Excel, allowing me to interact with it.
This is tedious, and if I were to share it to others, downright unusable, as not everyone knows how to use ALT TAB. You can't even minimize excel to find the popup box, since it's completely frozen.
How do you make sure that the popup box shows infront of the excel program? Even better, how do you make it so that it only opens the hyperlinked documents as Read Only? I have attempted to catch the hyperlink event in VBA and try to minimize excel, but excel just immediately freezes.
EDIT: This is not a VBA hyperlink, rather I have all the URLs and converted them to a hyperlinked cell (but still through VBA) since it's more 'convenient' to click on the word itself.
excel vba excel-vba hyperlink
excel vba excel-vba hyperlink
edited Nov 21 '18 at 7:38
Pᴇʜ
21.4k42750
asked Nov 20 '18 at 18:52
BasherBasher
25718
edited Nov 21 '18 at 7:38
Pᴇʜ
21.4k42750
asked Nov 20 '18 at 18:52
BasherBasher
25718
edited Nov 21 '18 at 7:38
Pᴇʜ
21.4k42750
edited Nov 21 '18 at 7:38
Pᴇʜ
21.4k42750
edited Nov 21 '18 at 7:38
Pᴇʜ
21.4k42750
21.4k42750
asked Nov 20 '18 at 18:52
BasherBasher
25718
asked Nov 20 '18 at 18:52
BasherBasher
25718
asked Nov 20 '18 at 18:52
BasherBasher
25718
25718
add a comment |
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%2f53399664%2fexcel-hyperlink-opening-a-write-reserved-document-causes-excel-to-freeze%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%2f53399664%2fexcel-hyperlink-opening-a-write-reserved-document-causes-excel-to-freeze%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
