how to enable disable macros in excel 2010

Note: By my analysis this will work fine, if we change macro setting to 'enable all macros' File -> Excel options, but I can't do it as in my office, those options are greyed out, and default setting is 'Disable all macros with notification. But in Office 2010, Evry time you open a macro file, it prompts with a message bar saying, 'macros are disabled' and an enable button, even this enabling works fine in individual file opening, but it comes to this above scenario, where the second file is automatically opened and closed by first file macro, in office 2010 when I click on enable. Is there any way where you can automate enabling the macro setting using the script. Last edited by a moderator: Jan 12, 2017. Enable Macros in two different versions of Excel: Excel 2007 Version. In Excel, macros are disabled by default for enhanced security. I will explain how to handle the enable macros in excel. Opened and closed by first file macro, in office 2010 when I click on enable content for second file, the Macro process stops. I have encountered a similar problem in excel. This works very much fine OfficeĢ003, because once I click on enable button for the first time, it will not ask for second file(XYZ.xlt).īut in Office 2010, Evry time you open a macro file, it prompts with a message bar saying, 'macros are disabled' and an enable button, even this enabling works fine in individual file opening, but it comes to this above scenario, where the second file is automatically There is a macro in ABC.xls which is run manually, once I run it, it asks me some values I give them and click ok, this macro in turns calls up XYZ.xlt and print a document, and then it will call PQR.xlt and print a document.

Trust Center -> Macro Settings -> 'Trust access to the VBA project model'. Excel 2010 options I've enabled: Trust Center -> Macro Settings -> 'Enable all macros'. Any help is greatly appreciated as my current workaround is to use another machine for my Excel work. I have three files, all files have macros in it, This occurs in every Excel sheet I work in (existing or new).

How to enable disable macros in excel 2010