View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mark H. Shin Mark H. Shin is offline
external usenet poster
 
Posts: 13
Default Macros disables under medium security

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...


"Charles" wrote in message
...
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!