I'm trying to automate code changes across a few dozen Excel files, but am having trouble (vbComponents).Remove-ing one of the modules. My only guess as to why this may be happening is because one of the macros in that module is being called on Workbook_Open. Is there any way to:
1) Disable all macros when opening a project (via VBA) but still allowing access to the code for .Remove/.Import
2) Force all running/active macros to end
3) Force a .Remove even on running/active modules
Thanks in advance.