K
KR
Based on Glenna Shaw's response to my last question, I went through the
selfcert process and created a certificate. I created a file (test.ppt) and
added a "hello world" msgbox macro, assigned the digital certificate in the
VBE, and saved the file.
On my own PC, when I open the file under high macro security, I get the
security warning box, with the following options: get details, disable
macros, enable macros, get more info, and there is a checkbox for "always
trust macros from this publisher". If I can get these options on all PC's, I
would be set- I can tell users to click "always trust..." then enable the
macros.
However, when I try to open the file on a different PC with high macro
security (our organization's default setting) that user gets the same
security warning box, except that the options to enable macros, and the
checkbox to "always trust..." are disabled/grey.
Is there any way for me to use a selfcert, and allow other users to trust my
macros (preferably "always trust...") without them having to reduce macro
security, and also without having to change anything more complicated on
their machine? Most users won't be comfortable moving files around anywhere
other than 'my documents'. I have no budget to get an external certificate,
so I'm stuck using self-cert or having to train everyone how to set macro
security to medium, assuming IT would even let me do that.
Thanks for any insight/suggestions-
Thanks,
Keith
selfcert process and created a certificate. I created a file (test.ppt) and
added a "hello world" msgbox macro, assigned the digital certificate in the
VBE, and saved the file.
On my own PC, when I open the file under high macro security, I get the
security warning box, with the following options: get details, disable
macros, enable macros, get more info, and there is a checkbox for "always
trust macros from this publisher". If I can get these options on all PC's, I
would be set- I can tell users to click "always trust..." then enable the
macros.
However, when I try to open the file on a different PC with high macro
security (our organization's default setting) that user gets the same
security warning box, except that the options to enable macros, and the
checkbox to "always trust..." are disabled/grey.
Is there any way for me to use a selfcert, and allow other users to trust my
macros (preferably "always trust...") without them having to reduce macro
security, and also without having to change anything more complicated on
their machine? Most users won't be comfortable moving files around anywhere
other than 'my documents'. I have no budget to get an external certificate,
so I'm stuck using self-cert or having to train everyone how to set macro
security to medium, assuming IT would even let me do that.
Thanks for any insight/suggestions-
Thanks,
Keith