![]() |
Problem with macro security
Good day everyone,
I have posted this message on the microsoft support newsgroup, but it has been unacessible to me for the past week and a half (whenever I try to go there, I get a "Service temporarily unavailable message). Has anyone else had this problem? My current problem is related to enabling and disabling macros in Excel. I have been having this problem with a few of our workstations for the past 3-4 months, but it has been getting more and more frequent (which makes me think it is linked to some update or other). The problem is that I have signed and unsigned macros. Some (but not all) of my users open one of the files containing macros on medium security, and they do not get the "Macros can contain viruses. You should only enable macros if you expect there to be macros or if you trust the person who has emitted the certificate" (not textual, but something to that effect) with the Enable macros / disable macros (and an option to always trust macros from that source when they are signed). Macros are just automatically disabled on medium security setting (again, whether they are signed or not does not make a difference), unless I change the security setting to low. Any ideas? Thanks! |
Problem with macro security
I ran into similar issues with macros I had written (and signed) using Excel
from Office 2000 and users were running more recent versions. You might need to create a digital certificate (use selfcert.exe from Office '03) and re-sign the existing macros using the new certificate. Then your users should be able to set their security level to medium and indicate that you are a trusted author. PLEASE don't have people running on low security! "Charles Rose-Lizée" wrote: Good day everyone, I have posted this message on the microsoft support newsgroup, but it has been unacessible to me for the past week and a half (whenever I try to go there, I get a "Service temporarily unavailable message). Has anyone else had this problem? My current problem is related to enabling and disabling macros in Excel. I have been having this problem with a few of our workstations for the past 3-4 months, but it has been getting more and more frequent (which makes me think it is linked to some update or other). The problem is that I have signed and unsigned macros. Some (but not all) of my users open one of the files containing macros on medium security, and they do not get the "Macros can contain viruses. You should only enable macros if you expect there to be macros or if you trust the person who has emitted the certificate" (not textual, but something to that effect) with the Enable macros / disable macros (and an option to always trust macros from that source when they are signed). Macros are just automatically disabled on medium security setting (again, whether they are signed or not does not make a difference), unless I change the security setting to low. Any ideas? Thanks! |
All times are GMT +1. The time now is 06:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com