opening document and disabling macros

Everytime my application object opens a document that has a macro, it runs the macro regardless of my security settings. Anyway to disable that


Answer this question

opening document and disabling macros

  • Alexander Gros

    I'm sorry you are having trouble with your macro settings. One of the things to consider is whether you have the Trust All Installed Add-ins and Templates checkbox selected.

    When this is selected, when your security setting is 'HIGH', macros in a specific location will still run. It's all explained here in great detail here:

    http://support.microsoft.com/ kbid=827725

    It is helpful to remember that this forum is mainly for issues that directly pertain to the Visual Studio Tools for Office tools per se. So you will be best served by posing this question to a forum or newsgroup wholly dedicated to applicaiton-specific issues such as yours. Below, you will find resources you should consult for best results.

    Regards,

    John R. Durant
    http://blogs.msdn.com/johnrdurant

    ------------------------
    VBA and General
    microsoft.public.office.developer.vba
    microsoft.public.office.developer.com.add_ins
    microsoft.public.office.developer.smarttags

    XML
    microsoft.public.office.xml

    Outlook
    microsoft.public.office.developer.outlook.vba
    microsoft.public.office.developer.outlook.forms
    microsoft.public.office.interop
    microsoft.public.office.program_addins
    microsoft.public.office.program_forms
    microsoft.public.office.program_vba
    http://msdn.microsoft.com/office/understanding/outlook

    Excel
    microsoft.public.excel.programming
    microsoft.public.excel.worksheet.functions
    http://msdn.microsoft.com/office/understanding/outlook

    Word
    microsoft.public.office.word.vba.addins
    microsoft.public.office.word.vba.beginners
    microsoft.public.office.word.vba.customization
    microsoft.public.office.word.vba.general
    microsoft.public.office.word.vba.userforms
    http://msdn.microsoft.com/office/understanding/word

    InfoPath
    microsoft.public.infopath
    http://msdn.microsoft.com/office/understanding/infopath


    MVP and 3rd Party Sites
    http://www.outlookcode.com
    http://www.officezealot.com



  • opening document and disabling macros