Macros disables under medium security

[Guest]

Good day everyone,

We have been having problems with some of the workstations in our network
for a few months now. The problem is the following: when a workbook
containing macros is opened, macros are automatically disabled without a
prompt even though the security level is set to medium. We have been having
problems with both macros that are signed (through selfcert) and unsigned.
Obviously, we have the same problem when the level is set to High and the
macro is signed. Everything works fine on Low security setting, but I would
prefer not to leave it there...

Thank you for your time!

 

[Mark H. Shin]

A self signed certifate is not created by a Trusted Certification Authority
(yourself in this case) therefore the Certification Path cannot be
determined and thus "untrusted".

You must use a digital certificate issued by a Trusted Certification
Authority in order to have the option to enable macros...

There are ways around this, but I won't elaborate on this here...

 

[Guest]

Thanks for the response, but we have been working with self-certification for
a few years now and it has always worked (and still does on most of our
computers). Also, shouldn't even unsigned macros trigger the "Enable/disable"
dialog on Medium Security? As it is right now, the only choice I have on the
few problematic stations is have security set on Low (so no security at all)
or not have any macros...

 

[Mark H. Shin]

Some versions of Office handle macro security differently. As you already
know. Office 2003 (at least on my machine???) does not offer the Enable
Macros button, which is disabled, even when Macro Security is set to Medium
when opening a Office project which is signed using a certificate created by
selfcert...

Are all your machines at the same Office version and update level, etc, etc?