Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros disables under medium security
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros disables under medium security
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? "Charles" wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros and security | Excel Worksheet Functions | |||
Macro security level in excel will not change to medium or low | Setting up and Configuration of Excel | |||
Macros Security | Excel Programming | |||
??Programmatically set security level to medium | Excel Programming | |||
Low Security and this runs, Medium it doesn't - Why? | Excel Programming |