Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Supressing the Macro security message programmatically.
I need to develop a C# assembly to run Excel files with Addins. As soon as I
open the Addin using the Workbook object Open method, I get the warning message box. This assembly is supposed to run silently in the background, so would appreciate a way of suppressing the warning. I have set the security level in Excel to lowest, but no success. Any ideas? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Supressing the Macro security message programmatically.
Three comments.
If you can suppress the warning programmatically, so can someone with malicious intent. If you intend this to be distributed to others, expecting them to set their security to 'low' may not be realistic. Even if you are in a position to force them to do so, it would leave them vulnerable to malicious attack. Consider loading the add-in through the AddIns collection rather than opening it through the Workbooks collection. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , =?Utf- 8?B?cGVuZyB3b25n?= <peng says... I need to develop a C# assembly to run Excel files with Addins. As soon as I open the Addin using the Workbook object Open method, I get the warning message box. This assembly is supposed to run silently in the background, so would appreciate a way of suppressing the warning. I have set the security level in Excel to lowest, but no success. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Security Message | Excel Discussion (Misc queries) | |||
how to get around the Enable Macro security message? | Excel Discussion (Misc queries) | |||
Display message upon file open even with macro security set to high | Excel Discussion (Misc queries) | |||
How can avoid the security Macro message ... | Excel Discussion (Misc queries) | |||
Bogus Excel 2002 Macro Security Message | Excel Programming |