How to Fix VBA Error 400
When some Excel users try to run their Macro, they seem to get a VBA error 400. There is only a box with an OK button and no other information.
Keep reading this article to learn how to fix this error in different ways.
Move your Macros to Another Module
Launch Microsoft Excel.
Go to Developer tab and select Visual Basic.
In the VBA menu, click Insert and select Module.
Paste the VBA code that you want to use.
Click on File menu and select Save.
Delete the old module.
Turn on trusted access
Launch Microsoft Excel.
Go to Developer tab and select Macro Security.
Under Developer Macro Settings, click on Trusted access to the VBA project.
Check your code for mistakes to fix VBA error 400
Make sure to check your code for mistakes all the time. Also, you need to make sure that none of the macros are broken.