Occasionally you’ll come across (or write code for) an Excel workbook where ActiveX objects are used - usually form controls. You would only tick Trust access to the VBA project object model if you’re creating sophisticated VBA code specifically designed to modify the code within your project’s Subroutines and Functions. In this case you would just need to set Excel to trust all macros for all files, like so…įile > Options > Trust Center > Trust Center Settings > Macro Settings > click Enable all macros Excel Trust Center – Enable macros by default
This could be problematic if you later need VBA to dynamically open these files for editing (the code would get stopped in its tracks!). However, if you rename the file, or if perhaps you have VBA save copies of the file with modified file names, you’ll see the warning again for each new file-name.
… just click Enable Content and Excel will remember your choice, and the next time you open this file you won’t get the warning. Excel – ‘Security Warning macros have been disabled’
0 kommentar(er)
