![visual basic for applications 2010 visual basic for applications 2010](http://www.projectwoman.com/articles/images/30step6.jpg)
Step 2: Under “Developer Macro Settings” check “Trusted Access to the VBA project.” Other More Advanced Methods Step 1: Select the Developer tab on the Excel menu, go to the Code group and click on Macro Security. Note: Make sure to delete the old module. Step 4: Navigate to the File menu and click on Save Global. Step 3: Paste the VBA code that you want to use. Step 2: Select the Insert tab of the VBA Editor and click on the Module option or click on Tools > Macro then name the macro and press Enter Step 1: Select the developer tab on the Excel menu and click on the Visual Basic option or Click on Alt + F11 simultaneously. However, I strongly advise you to check your macro very well to be certain that the error is not coming from the code itself before attempting any fix. Consequently, you might have to try one or a combination of the methods below to fix the problem. The VBA 400 error message does not give any indication on the origin of the error. Note: VBA 400 error messages can arise in any of the following Microsoft Windows operating systems: Windows 10, Windows 8, Windows 7, Windows Vista, Windows XP, Windows ME, Windows 2000.
Visual basic for applications 2010 software#
![visual basic for applications 2010 visual basic for applications 2010](https://images-na.ssl-images-amazon.com/images/I/51KMZo627fL._SX332_BO1,204,203,200_.jpg)
What Are the Causes of VBA Error 400?Įxcel error 400 occurs when Microsoft Excel fails or crashes while running.
![visual basic for applications 2010 visual basic for applications 2010](https://www.excel-easy.com/smi/vba/examples/option-explicit-2.png)
Visual basic for applications 2010 how to#
In the following article, we shall see the possible causes of this error (there are many of them) and how to fix them. If as a VBA coder you have come across the VBA error 400 and do not know what to do, then this article is for you. You only know that there is an error because you see the red cross on the message box with the number 400 referring to the error number. But as you can see from the above screenshot the VBA Error 400 is one of those annoying types of error that does not give you any information on the origin of the bug of your code. It is often said that debugging is part of programming, and through error messages, the programmer can easily identify where there are problems in his/her code.