How to Fix VBA Error 400 You can debug the code and execute each line of code 1 by 1. You can shift the entire macro to a new module. You can also Switch on the trusted VBA project that gives full access to the code to run.