View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
charles charles is offline
external usenet poster
 
Posts: 124
Default Macros disables under medium security

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" wrote:

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!