ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Problem with macro security (https://www.excelbanter.com/excel-programming/346282-problem-macro-security.html)

Charles Rose-Lizée

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!



bpeltzer

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!




Charles Rose-Lizée

Problem with macro security
 
Thanks for the response, but I don't think that is the problem I am
currently having as the users who have reported the problem were using
Office 2000 (and the macros were created using Office 2000). Also, we have a
few users who use Office 2003 and who use my macros, and they don't seem to
have this issue.

"bpeltzer" a écrit dans le message de
news: ...
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