To enable/disable via Regedit : Registry Key to change: [HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Security] "VBAWarnings"=dword:00000001 Registry Option Values: •1 = Enable all macros (not recommended; potentially dangerous code can run) •2 = Disable all macros except digitall...
At times, you might not want to prevent macros, ActiveX control, data connections, etc., from running in a Word document, Excel spreadsheet, or PowerPoint presentation. If so, you can disable or turn off Trusted Documents features in Word, Excel, and PowerPoint. This explains how you can ...
VBA - How to programmatically enable access to the VBA object model using macros 项目 2012/02/29 Under certain circumstances a programmer may need to access the VB object model for an Office application and interact with its VBIDE interface (clean-up missing referen...