Excel 2002 Security Issue
When a user opens an Excel file that has macros, and if there security is set
to medium or high, they get that dialog box that asks them whether or not to enable macros. With macro security set to Medium in Excle 2002, is there a way to disable the request. I have tried checking both check boxes in Trusted Sources, to no avail. Thanks for any guidance. |
Excel 2002 Security Issue
The trusted sources approach will work, but only if the macros have a digital
signature (indicating a source whom you can trust). The cheap way to create those signatures is for the macro author to find and run the selfcert.exe file (part of the Office installation). Then open the macro in the VB Editor, and from the menu bar choose Tools Digital Signature and select the certificate; save and close. Now the users will have the ability to indicate that the author is a trusted source, and thereby bypass the dialog if security is set to medium. (Note: I've found that certificates created under old versions aren't recognized by newer versions, so the signer should use as recent a version of Office as the users will). HTH. --Bruce "PA" wrote: When a user opens an Excel file that has macros, and if there security is set to medium or high, they get that dialog box that asks them whether or not to enable macros. With macro security set to Medium in Excle 2002, is there a way to disable the request. I have tried checking both check boxes in Trusted Sources, to no avail. Thanks for any guidance. |
Excel 2002 Security Issue
Sounds promising, I will give it a try - THANK YOU
"bpeltzer" wrote: The trusted sources approach will work, but only if the macros have a digital signature (indicating a source whom you can trust). The cheap way to create those signatures is for the macro author to find and run the selfcert.exe file (part of the Office installation). Then open the macro in the VB Editor, and from the menu bar choose Tools Digital Signature and select the certificate; save and close. Now the users will have the ability to indicate that the author is a trusted source, and thereby bypass the dialog if security is set to medium. (Note: I've found that certificates created under old versions aren't recognized by newer versions, so the signer should use as recent a version of Office as the users will). HTH. --Bruce "PA" wrote: When a user opens an Excel file that has macros, and if there security is set to medium or high, they get that dialog box that asks them whether or not to enable macros. With macro security set to Medium in Excle 2002, is there a way to disable the request. I have tried checking both check boxes in Trusted Sources, to no avail. Thanks for any guidance. |
All times are GMT +1. The time now is 06:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com