Office 2010 macro issues
I have some macro enabled word documents that worked fine in Word 2003, but in 2010 I cannot get the macro security settings to behave properly.
When I first open a macro enabled document, I get this popup:
At the same time, along the top of Word, just under the ribbon, this bar appears:
After clicking [OK] on the first warning, the "Security Warning" prompt bar dissappears, so I cannot click the [Enable Content] button. This issue occurs even when the file resides in a network location that is trusted. The only fix I've been able to come up with is to enable all macros on all documents, but obviously that isn't the safest way of doing things.
I've tried changing numerous setting combinations in the Trust Center, but still have the same problem. Any ideas?
microsoft-word microsoft-office macros microsoft-word-2010
asked Nov 7 '11 at 15:01
dmuxdmux
5114
add a comment |
I have some macro enabled word documents that worked fine in Word 2003, but in 2010 I cannot get the macro security settings to behave properly.
When I first open a macro enabled document, I get this popup:
At the same time, along the top of Word, just under the ribbon, this bar appears:
After clicking [OK] on the first warning, the "Security Warning" prompt bar dissappears, so I cannot click the [Enable Content] button. This issue occurs even when the file resides in a network location that is trusted. The only fix I've been able to come up with is to enable all macros on all documents, but obviously that isn't the safest way of doing things.
I've tried changing numerous setting combinations in the Trust Center, but still have the same problem. Any ideas?
microsoft-word microsoft-office macros microsoft-word-2010
asked Nov 7 '11 at 15:01
dmuxdmux
5114
add a comment |
I have some macro enabled word documents that worked fine in Word 2003, but in 2010 I cannot get the macro security settings to behave properly.
When I first open a macro enabled document, I get this popup:
At the same time, along the top of Word, just under the ribbon, this bar appears:
After clicking [OK] on the first warning, the "Security Warning" prompt bar dissappears, so I cannot click the [Enable Content] button. This issue occurs even when the file resides in a network location that is trusted. The only fix I've been able to come up with is to enable all macros on all documents, but obviously that isn't the safest way of doing things.
I've tried changing numerous setting combinations in the Trust Center, but still have the same problem. Any ideas?
microsoft-word microsoft-office macros microsoft-word-2010
asked Nov 7 '11 at 15:01
dmuxdmux
5114
I have some macro enabled word documents that worked fine in Word 2003, but in 2010 I cannot get the macro security settings to behave properly.
When I first open a macro enabled document, I get this popup:
At the same time, along the top of Word, just under the ribbon, this bar appears:
After clicking [OK] on the first warning, the "Security Warning" prompt bar dissappears, so I cannot click the [Enable Content] button. This issue occurs even when the file resides in a network location that is trusted. The only fix I've been able to come up with is to enable all macros on all documents, but obviously that isn't the safest way of doing things.
I've tried changing numerous setting combinations in the Trust Center, but still have the same problem. Any ideas?
microsoft-word microsoft-office macros microsoft-word-2010
microsoft-word microsoft-office macros microsoft-word-2010
asked Nov 7 '11 at 15:01
dmuxdmux
5114
asked Nov 7 '11 at 15:01
dmuxdmux
5114
asked Nov 7 '11 at 15:01
dmuxdmux
5114
asked Nov 7 '11 at 15:01
dmuxdmux
5114
asked Nov 7 '11 at 15:01
dmuxdmux
5114
5114
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
This sounds like an issue with the macro itself. You should check the macro for depreciated commands and functions.
answered Nov 8 '11 at 10:17
surfasbsurfasb
20.8k34371
Thanks for your reply. I wasn't able to troubleshoot this issue for a few weeks, but I got around to testing today. I've gone through the code and haven't been able to find anything that's considered depreciated. Any other ideas?
– dmux
Nov 29 '11 at 21:01
add a comment |
Not sure if you are still watching this thread but I had this same issue. It was because I had an auto open macro in a template. What was happening is the auto-open macro was trying to run before I click the button to enable macros. Unfortunately the box to enable macros is disabled until you click the error (as you show above).
You can confirm this behavior by holding shift when you open the document to skip auto-run macros.
Then you can go to view...macros... and run the auto open manually.
If you add the template to the trusted sites list it should enable macros for the file before opening the doc, however you wont get the prompt. I am still trying to figure that out, e.g., prompting me to enable, before trying to execute the autorun.
edited Nov 3 '12 at 8:14
jonsca
3,030112540
answered Apr 9 '12 at 18:12
ted midthunted midthun
1
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
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%2fsuperuser.com%2fquestions%2f354792%2foffice-2010-macro-issues%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
This sounds like an issue with the macro itself. You should check the macro for depreciated commands and functions.
answered Nov 8 '11 at 10:17
surfasbsurfasb
20.8k34371
Thanks for your reply. I wasn't able to troubleshoot this issue for a few weeks, but I got around to testing today. I've gone through the code and haven't been able to find anything that's considered depreciated. Any other ideas?
– dmux
Nov 29 '11 at 21:01
add a comment |
This sounds like an issue with the macro itself. You should check the macro for depreciated commands and functions.
answered Nov 8 '11 at 10:17
surfasbsurfasb
20.8k34371
Thanks for your reply. I wasn't able to troubleshoot this issue for a few weeks, but I got around to testing today. I've gone through the code and haven't been able to find anything that's considered depreciated. Any other ideas?
– dmux
Nov 29 '11 at 21:01
add a comment |
This sounds like an issue with the macro itself. You should check the macro for depreciated commands and functions.
answered Nov 8 '11 at 10:17
surfasbsurfasb
20.8k34371
This sounds like an issue with the macro itself. You should check the macro for depreciated commands and functions.
answered Nov 8 '11 at 10:17
surfasbsurfasb
20.8k34371
answered Nov 8 '11 at 10:17
surfasbsurfasb
20.8k34371
answered Nov 8 '11 at 10:17
surfasbsurfasb
20.8k34371
answered Nov 8 '11 at 10:17
surfasbsurfasb
20.8k34371
20.8k34371
Thanks for your reply. I wasn't able to troubleshoot this issue for a few weeks, but I got around to testing today. I've gone through the code and haven't been able to find anything that's considered depreciated. Any other ideas?
– dmux
Nov 29 '11 at 21:01
add a comment |
Thanks for your reply. I wasn't able to troubleshoot this issue for a few weeks, but I got around to testing today. I've gone through the code and haven't been able to find anything that's considered depreciated. Any other ideas?
– dmux
Nov 29 '11 at 21:01
Thanks for your reply. I wasn't able to troubleshoot this issue for a few weeks, but I got around to testing today. I've gone through the code and haven't been able to find anything that's considered depreciated. Any other ideas?
– dmux
Nov 29 '11 at 21:01
Thanks for your reply. I wasn't able to troubleshoot this issue for a few weeks, but I got around to testing today. I've gone through the code and haven't been able to find anything that's considered depreciated. Any other ideas?
– dmux
Nov 29 '11 at 21:01
add a comment |
Not sure if you are still watching this thread but I had this same issue. It was because I had an auto open macro in a template. What was happening is the auto-open macro was trying to run before I click the button to enable macros. Unfortunately the box to enable macros is disabled until you click the error (as you show above).
You can confirm this behavior by holding shift when you open the document to skip auto-run macros.
Then you can go to view...macros... and run the auto open manually.
If you add the template to the trusted sites list it should enable macros for the file before opening the doc, however you wont get the prompt. I am still trying to figure that out, e.g., prompting me to enable, before trying to execute the autorun.
edited Nov 3 '12 at 8:14
jonsca
3,030112540
answered Apr 9 '12 at 18:12
ted midthunted midthun
1
add a comment |
Not sure if you are still watching this thread but I had this same issue. It was because I had an auto open macro in a template. What was happening is the auto-open macro was trying to run before I click the button to enable macros. Unfortunately the box to enable macros is disabled until you click the error (as you show above).
You can confirm this behavior by holding shift when you open the document to skip auto-run macros.
Then you can go to view...macros... and run the auto open manually.
If you add the template to the trusted sites list it should enable macros for the file before opening the doc, however you wont get the prompt. I am still trying to figure that out, e.g., prompting me to enable, before trying to execute the autorun.
edited Nov 3 '12 at 8:14
jonsca
3,030112540
answered Apr 9 '12 at 18:12
ted midthunted midthun
1
add a comment |
Not sure if you are still watching this thread but I had this same issue. It was because I had an auto open macro in a template. What was happening is the auto-open macro was trying to run before I click the button to enable macros. Unfortunately the box to enable macros is disabled until you click the error (as you show above).
You can confirm this behavior by holding shift when you open the document to skip auto-run macros.
Then you can go to view...macros... and run the auto open manually.
If you add the template to the trusted sites list it should enable macros for the file before opening the doc, however you wont get the prompt. I am still trying to figure that out, e.g., prompting me to enable, before trying to execute the autorun.
edited Nov 3 '12 at 8:14
jonsca
3,030112540
answered Apr 9 '12 at 18:12
ted midthunted midthun
1
Not sure if you are still watching this thread but I had this same issue. It was because I had an auto open macro in a template. What was happening is the auto-open macro was trying to run before I click the button to enable macros. Unfortunately the box to enable macros is disabled until you click the error (as you show above).
You can confirm this behavior by holding shift when you open the document to skip auto-run macros.
Then you can go to view...macros... and run the auto open manually.
If you add the template to the trusted sites list it should enable macros for the file before opening the doc, however you wont get the prompt. I am still trying to figure that out, e.g., prompting me to enable, before trying to execute the autorun.
edited Nov 3 '12 at 8:14
jonsca
3,030112540
answered Apr 9 '12 at 18:12
ted midthunted midthun
1
edited Nov 3 '12 at 8:14
jonsca
3,030112540
edited Nov 3 '12 at 8:14
jonsca
3,030112540
edited Nov 3 '12 at 8:14
jonsca
3,030112540
3,030112540
answered Apr 9 '12 at 18:12
ted midthunted midthun
1
answered Apr 9 '12 at 18:12
ted midthunted midthun
1
answered Apr 9 '12 at 18:12
ted midthunted midthun
1
1
add a comment |
add a comment |
Thanks for contributing an answer to Super User!
- 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%2fsuperuser.com%2fquestions%2f354792%2foffice-2010-macro-issues%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
