Diasbling Security settings in Microsoft Excel


  • Hi all

    My friend uses Visual Basic Application code embedded in a Excel Worksheet for his application.

    When the machine has the EXcel MAcro Security as 'High' (Tools--> Macro --> Security) the macro fails to get executed. How to turn off the security (make it Low) from Visual Basic / C# code.



    sexta-feira, 30 de dezembro de 2005 05:26


  • The right way to go about this would be to digitally sign the VB code. If it's an application that is going to be run on the same machine where the code was created, you can use SelfCert.exe (Digital Certicate for VBA projects in the Microsoft Office Tools menu) to create your own personal digital certificate; otherwise I think you need a commercial certificate from someone like VeriSign.
    sexta-feira, 30 de dezembro de 2005 08:46