View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
bpeltzer bpeltzer is offline
external usenet poster
 
Posts: 180
Default 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!