How do you self sign a macro for Microsoft Office for a non admin user
I am trying to self sign a macro that I wrote for Outlook, and my searches lead to SelfCert.exe
I ran SelfCert.exe and was able to make a self signed certificate, and inside of Outlook I was able to select that certificate for signing my macro.
The problem is that every time I restart Outlook, my macros are disabled. I think they are disabled because the self signed certificate I created is not installed in my Trusted Root Certification Authorities
My Macro Settings under the Trust Center are set to Notifications for all macros which seemed the most appropriate because the only other options are Disable all macros without notification Notifications for digitally signed macros, all other macros disabled and Enable all macros.
I do my day to do work with a non admin account and only log in to the local admin account when needed, so the self signed certificate is associated with my non admin user. If I run SelfCert.exe as administrator, I can make a self signed certificate associated with my admin user, but I can't select that certificate to sign my macros in Outlook because I'm running Outlook as my normal non admin account.
If I use mmc to manage certificates, I can only see the certificate generated with the admin user under Certificates - Current User -> Personal -> Certificates, and I can't see how to access the certificate created with my non admin account because I can't use mmc with my non admin account.
How can I get that self signed certificate, created with my non admin account, installed into my Trusted Root Certificate Authorities so I can sign my Outlook macros?
microsoft-outlook microsoft-office macros trusted-root-certificates
asked Dec 13 '18 at 19:33
TJ RockefellerTJ Rockefeller
1011
add a comment |
I am trying to self sign a macro that I wrote for Outlook, and my searches lead to SelfCert.exe
I ran SelfCert.exe and was able to make a self signed certificate, and inside of Outlook I was able to select that certificate for signing my macro.
The problem is that every time I restart Outlook, my macros are disabled. I think they are disabled because the self signed certificate I created is not installed in my Trusted Root Certification Authorities
My Macro Settings under the Trust Center are set to Notifications for all macros which seemed the most appropriate because the only other options are Disable all macros without notification Notifications for digitally signed macros, all other macros disabled and Enable all macros.
I do my day to do work with a non admin account and only log in to the local admin account when needed, so the self signed certificate is associated with my non admin user. If I run SelfCert.exe as administrator, I can make a self signed certificate associated with my admin user, but I can't select that certificate to sign my macros in Outlook because I'm running Outlook as my normal non admin account.
If I use mmc to manage certificates, I can only see the certificate generated with the admin user under Certificates - Current User -> Personal -> Certificates, and I can't see how to access the certificate created with my non admin account because I can't use mmc with my non admin account.
How can I get that self signed certificate, created with my non admin account, installed into my Trusted Root Certificate Authorities so I can sign my Outlook macros?
microsoft-outlook microsoft-office macros trusted-root-certificates
asked Dec 13 '18 at 19:33
TJ RockefellerTJ Rockefeller
1011
I'm not sure, but "Notifications for digitally signed macros, all other macros disabled" seems to suggest that signed macros will be enabled. Have you tried that?
– Scott
Dec 13 '18 at 19:41
add a comment |
I am trying to self sign a macro that I wrote for Outlook, and my searches lead to SelfCert.exe
I ran SelfCert.exe and was able to make a self signed certificate, and inside of Outlook I was able to select that certificate for signing my macro.
The problem is that every time I restart Outlook, my macros are disabled. I think they are disabled because the self signed certificate I created is not installed in my Trusted Root Certification Authorities
My Macro Settings under the Trust Center are set to Notifications for all macros which seemed the most appropriate because the only other options are Disable all macros without notification Notifications for digitally signed macros, all other macros disabled and Enable all macros.
I do my day to do work with a non admin account and only log in to the local admin account when needed, so the self signed certificate is associated with my non admin user. If I run SelfCert.exe as administrator, I can make a self signed certificate associated with my admin user, but I can't select that certificate to sign my macros in Outlook because I'm running Outlook as my normal non admin account.
If I use mmc to manage certificates, I can only see the certificate generated with the admin user under Certificates - Current User -> Personal -> Certificates, and I can't see how to access the certificate created with my non admin account because I can't use mmc with my non admin account.
How can I get that self signed certificate, created with my non admin account, installed into my Trusted Root Certificate Authorities so I can sign my Outlook macros?
microsoft-outlook microsoft-office macros trusted-root-certificates
asked Dec 13 '18 at 19:33
TJ RockefellerTJ Rockefeller
1011
I am trying to self sign a macro that I wrote for Outlook, and my searches lead to SelfCert.exe
I ran SelfCert.exe and was able to make a self signed certificate, and inside of Outlook I was able to select that certificate for signing my macro.
The problem is that every time I restart Outlook, my macros are disabled. I think they are disabled because the self signed certificate I created is not installed in my Trusted Root Certification Authorities
My Macro Settings under the Trust Center are set to Notifications for all macros which seemed the most appropriate because the only other options are Disable all macros without notification Notifications for digitally signed macros, all other macros disabled and Enable all macros.
I do my day to do work with a non admin account and only log in to the local admin account when needed, so the self signed certificate is associated with my non admin user. If I run SelfCert.exe as administrator, I can make a self signed certificate associated with my admin user, but I can't select that certificate to sign my macros in Outlook because I'm running Outlook as my normal non admin account.
If I use mmc to manage certificates, I can only see the certificate generated with the admin user under Certificates - Current User -> Personal -> Certificates, and I can't see how to access the certificate created with my non admin account because I can't use mmc with my non admin account.
How can I get that self signed certificate, created with my non admin account, installed into my Trusted Root Certificate Authorities so I can sign my Outlook macros?
microsoft-outlook microsoft-office macros trusted-root-certificates
microsoft-outlook microsoft-office macros trusted-root-certificates
asked Dec 13 '18 at 19:33
TJ RockefellerTJ Rockefeller
1011
asked Dec 13 '18 at 19:33
TJ RockefellerTJ Rockefeller
1011
asked Dec 13 '18 at 19:33
TJ RockefellerTJ Rockefeller
1011
asked Dec 13 '18 at 19:33
TJ RockefellerTJ Rockefeller
1011
asked Dec 13 '18 at 19:33
TJ RockefellerTJ Rockefeller
1011
1011
I'm not sure, but "Notifications for digitally signed macros, all other macros disabled" seems to suggest that signed macros will be enabled. Have you tried that?
– Scott
Dec 13 '18 at 19:41
add a comment |
I'm not sure, but "Notifications for digitally signed macros, all other macros disabled" seems to suggest that signed macros will be enabled. Have you tried that?
– Scott
Dec 13 '18 at 19:41
I'm not sure, but "Notifications for digitally signed macros, all other macros disabled" seems to suggest that signed macros will be enabled. Have you tried that?
– Scott
Dec 13 '18 at 19:41
I'm not sure, but "Notifications for digitally signed macros, all other macros disabled" seems to suggest that signed macros will be enabled. Have you tried that?
– Scott
Dec 13 '18 at 19:41
add a comment |
1 Answer
1
active
oldest
votes
I was about to add screenshots to my question when I realized that the security warning popup in Outlook had an option to trust all items from this publisher (referring to my self signed certificate). After selecting that, it looks like my self signed certificate was added to whatever certificate store it needed to be added to for Outlook to trust my macros. Now that I've trusted that certificate I'm not getting the security popup any more, and therefore can't add a screenshot of that popup to my question or to this answer.
answered Dec 13 '18 at 19:44
TJ RockefellerTJ Rockefeller
1011
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%2f1383385%2fhow-do-you-self-sign-a-macro-for-microsoft-office-for-a-non-admin-user%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
I was about to add screenshots to my question when I realized that the security warning popup in Outlook had an option to trust all items from this publisher (referring to my self signed certificate). After selecting that, it looks like my self signed certificate was added to whatever certificate store it needed to be added to for Outlook to trust my macros. Now that I've trusted that certificate I'm not getting the security popup any more, and therefore can't add a screenshot of that popup to my question or to this answer.
answered Dec 13 '18 at 19:44
TJ RockefellerTJ Rockefeller
1011
add a comment |
I was about to add screenshots to my question when I realized that the security warning popup in Outlook had an option to trust all items from this publisher (referring to my self signed certificate). After selecting that, it looks like my self signed certificate was added to whatever certificate store it needed to be added to for Outlook to trust my macros. Now that I've trusted that certificate I'm not getting the security popup any more, and therefore can't add a screenshot of that popup to my question or to this answer.
answered Dec 13 '18 at 19:44
TJ RockefellerTJ Rockefeller
1011
add a comment |
I was about to add screenshots to my question when I realized that the security warning popup in Outlook had an option to trust all items from this publisher (referring to my self signed certificate). After selecting that, it looks like my self signed certificate was added to whatever certificate store it needed to be added to for Outlook to trust my macros. Now that I've trusted that certificate I'm not getting the security popup any more, and therefore can't add a screenshot of that popup to my question or to this answer.
answered Dec 13 '18 at 19:44
TJ RockefellerTJ Rockefeller
1011
I was about to add screenshots to my question when I realized that the security warning popup in Outlook had an option to trust all items from this publisher (referring to my self signed certificate). After selecting that, it looks like my self signed certificate was added to whatever certificate store it needed to be added to for Outlook to trust my macros. Now that I've trusted that certificate I'm not getting the security popup any more, and therefore can't add a screenshot of that popup to my question or to this answer.
answered Dec 13 '18 at 19:44
TJ RockefellerTJ Rockefeller
1011
answered Dec 13 '18 at 19:44
TJ RockefellerTJ Rockefeller
1011
answered Dec 13 '18 at 19:44
TJ RockefellerTJ Rockefeller
1011
answered Dec 13 '18 at 19:44
TJ RockefellerTJ Rockefeller
1011
1011
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%2f1383385%2fhow-do-you-self-sign-a-macro-for-microsoft-office-for-a-non-admin-user%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
I'm not sure, but "Notifications for digitally signed macros, all other macros disabled" seems to suggest that signed macros will be enabled. Have you tried that?
– Scott
Dec 13 '18 at 19:41