If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel 2002 Add-in: Open Database Connectivity available for Excel | 123user | General Discussion | 4 | December 7th, 2006 06:04 PM |
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | MEGTOM | New Users | 5 | October 27th, 2005 03:06 AM |
Excel 2003 Print Issue | TheRobsterUK | General Discussion | 2 | September 26th, 2005 04:59 PM |
sharing/using/saving Excel 2002 files in Excel 2003 | maze2009 | General Discussion | 0 | January 20th, 2005 07:27 PM |
Excel 2002 and 2000 co-install. Control Which Starts ? | cnuk | General Discussion | 2 | January 17th, 2005 08:07 PM |