Maqaalkan, waxaan ka wada hadli doonaa hababka ku saabsan sida loo hagaajiyo qaladka VBA 400 ee Excel^{(how to fix VBA error 400 in Excel)} . Cilada 400 ee Excel inta badan waxay dhacdaa marka la wado Microsoft Visual Basic for Applications ( VBA ) macro. Waxay sababtaa in macrosku burburo ama ku guuldareysto inuu ordo oo uu soo celiyo qalad 400 fariin ah. Hadda, waxaa jiri kara sababo kala duwan oo khaladkaas ah; aan ka doodno.

Maxaa sababa qaladka VBA 400 ee Excel?

Waa kuwan sababaha ay ugu wacan tahay qaladka 400 uu kiciyo marka uu ku shaqeynayo Macro gudaha Excel :

• Qallad^(Faulty) ku rakibida software- ka Xafiiska^(Office)
• Waxaa jira xoogaa khalad ah oo ku jira koodka VBA .
• Qiimaha aan sax ahayn ee doodda
• Macro ordaya ayaa kharribmay.
• Faylasha laxiriira Excel ee ay qaadeen malware-ka qaarkood.
• Ku guuldareysiga inaad wax ka akhrido/qorto faylka.
• Gelida diiwaanka aan ansax ahayn

Haddii aad la kulanto qaladka 400 gudaha Excel , waxaad isticmaali kartaa xalalka hoos ku qoran si aad u xalliso.

Sida loo hagaajiyo qaladka VBA 400 gudaha Excel

Waa kuwan hababka lagu saxo qaladka 400 ee la kulma inta lagu guda jiro macro gudaha Excel :

1. U guuri Macros Module cusub.
2. U oggolow gelitaanka la aaminsan yahay ee VBA.
3. Dib u eeg summadaada VBA-da
4. Dayactir Microsoft Excel.
5. Uninstall, ka dibna dib u rakib Excel .
6. Qaar ka mid ah hababka kale sida iskaanka malware, iwm.

Aynu si faahfaahsan uga hadalno hababkan.

1] Macros u guuri Module cusub

U wareejinta macroskaaga cutub cusub ayaa xalin kara arrinta haddii ay dhacdo khalad dibadda ah. Waxaad isticmaali kartaa tillaabooyinka soo socda si aad sidaas u sameyso:

Tag tab horumariyeyaasha^{( Developers)} oo guji ikhtiyaarka tifaftiraha ^(editor)Visual . Haddii ay dhacdo inaad arki weydo tabka horumariyeyaasha^(Developers) ee ku yaal ribbonka ugu weyn ee Excel , tag File >Options and Customize Ribbons tab, shid sanduuqa hubinta ee horumariyeyaasha ee qaybta ^(Developers)Tabs^{(Main Tabs)} ee ugu weyn .

Hadda, gudaha daaqada Microsoft Visual Basic ee Codsiyada^{( Microsoft Visual Basic for Applications)} , dhagsii liiska Gelida^(Insert) ka dibna xulashada Module .

Taas ka dib, ku dheji Macro^(Macro) code-kaaga cutubkan cusub oo ku keydi adiga oo isticmaalaya ikhtiyaarka u go'an ee ka jira menu File .

Sidoo kale, waxaad u baahan tahay inaad tirtirto cutubkii hore adigoo midig-gujinaya oo isticmaalaya ikhtiyaarka saar .^(Remove)

Ugu dambeyntii, dhagsii File > Close oo Ku Soo noqo^(Return) xulashada Microsoft Excel oo arag haddii qaladka 400 lagu xalliyo Excel .

2] Daree gelida la aamini karo ee VBA

Waxaad shidi kartaa marinka lagu kalsoon yahay ee VBA oo arag haddii arintu meesha ka baxday. Waa kuwan tillaabooyinka lagu suurtagelinayo gelitaanka la aaminsan yahay ee VBA :

1. U dhaqaaq tab horumariyeyaasha^(Developers) oo guji ikhtiyaarka Amniga Macros .^{(Macros Security)}
2. Daaqadda Xarunta Trust^{(Trust Centre)} , u sahli ikhtiyaarka lagu magacaabo Helitaanka Aaminsan ee qaabka shayga mashruuca VBA^{(Trusted access to the VBA project object model)} .
3. Riix badhanka OK

3] Dib u eeg koodkaaga

Cilad ku jirta koodka VBA wuxuu kicin karaa qaladka 400 ee Excel . Markaa, waxaad u baahan tahay inaad si fiican dib u eegto koodhka macro oo aad saxdo khaladka koodhka haddii uu jiro. Sidoo kale, hubi macros haddii uu jiro wax musuqmaasuq ah.

4] Dayactir Microsoft Excel

Haddi kuwan sare aanu midkoodna shaqayn, dhibaatadu waxa ay ahaan kartaa app -ka Excel . Codsiga waxaa laga yaabaa in si khaldan loo rakibo ama shay ayaa u baahan in la dayactiro. Haddaba, dayactirka Microsoft Excel adoo isticmaalaya tillaabooyinka soo socda:

1. Fur abka Settings^{(Launch Settings app)} oo aad Apps> Apps & features.
2. Dhanka midig, hel oo dhagsii barnaamijka Office 365/ Microsoft 365 .
3. Taabo badhanka wax ka beddel^(Modify) ka dibna dooro Dayactirka khadka tooska^{(Online Repair)} ah ama ikhtiyaarka dayactirka degdega^{(Quick Repair)} ah.
4. Riix^(Press) badhanka Dayactirka^(Repair) kaas oo dib u hagaajinaya Excel iyo barnaamijyada kale ee Xafiiska^(Office) .

5] Uninstall , ka dibna dib u rakib Excel

Waxa kale oo aad isku dayi kartaa in aad uninstall-ka ka saarto oo aad dib u rakibto Office iyo software Excel si aad dib ugu bilowdo. Eeg haddii ay tani hagaajinayso khaladka.

6] Qaar ka mid ah hababka kale

Sidoo kale, qaar ka mid ah xalalka kale ayaa sidoo kale u shaqeyn kara sida:

• Waxaad isku dayi kartaa inaad socodsiiso iskaanka SFC si aad u hubiso una dayactirto faylalka nidaamka xumaaday.
• Qaar ka mid ah barnaamijyada xaasidnimada leh ayaa sidoo kale keeni kara qaladkan. Marka, ka hubi oo ka saar malware-ka iyo arjiga shakiga leh ee Microsoft Defender ama antivirus qolo saddexaad ama barnaamijka antimalware .
• Isku day inaad tirtirto xogta khasnado xumaatay iyo nidaamka faylalka junk

Waxaan rajeyneynaa in xalalka sare ay ku caawiyaan!

Hadda akhri: ^{(Now read: )}Sida loo hagaajiyo qaladka Runtime 1004 ee Excel^{(How to Fix Runtime Error 1004 in Excel)}

How to fix VBA error 400 in Excel

In this article, we are going to discuss methods on how to fix VBA error 400 in Excel. The error 400 in Excel usually occurs while running a Microsoft Visual Basic for Applications (VBA) macro. It causes the macros to crash or fail to run and return an error 400 message. Now, there can be different reasons for such an error; let us discuss them.

What causes VBA error 400 in Excel?

Here are the reasons due to which error 400 is triggered when running a Macro in Excel:

• Faulty installation of the Office software.
• There is some error in the VBA code.
• Invalid value in the argument.
• The running macro is corrupted.
• Excel-related files infected by some malware.
• Failure to read/ write from a file.
• Invalid registry entries.

If you are encountering error 400 in Excel, you can use the below-listed solutions to resolve it.

How to fix VBA error 400 in Excel

Here are the methods to fix error 400 encountered while running a macro in Excel:

1. Move Macros to a new Module.
2. Enable trusted access to VBA.
3. Review your VBA code.
4. Repair Microsoft Excel.
5. Uninstall, and then reinstall Excel.
6. Some other methods like scan for malware, etc.

Let us discuss these methods elaborately.

1] Move Macros to a new Module

Transferring your macros to a new module may fix the issue in case there is some external error. You can use the below steps to do so:

Go to the Developers tab and click on the Visual editor option. In case you don’t see the Developers tab on the main ribbon in Excel, go to File > Options and from Customize Ribbons tab, turn on the Developers checkbox from the Main Tabs section.

Now, in the Microsoft Visual Basic for Applications window, click on the Insert menu and then the Module option.

After that, paste your Macro code into this new module and save it using the dedicated option from the File menu.

Also, you need to delete the old module by right-clicking it and using the Remove option.

At last, click the File > Close and Return to Microsoft Excel option and see if the error 400 is resolved in Excel.

2] Enable trusted access to VBA

You can turn on the trusted access to VBA and see if the issue is gone. Here are the steps to enable trusted access to VBA:

1. Move to the Developers tab and click on the Macros Security option.
2. In the Trust Centre window, enable the option named Trusted access to the VBA project object model.
3. Press the OK button.

3] Review your code

An error in VBA code can trigger error 400 in Excel. So, you need to thoroughly review the macro code and correct the error in the code if any. Also, check macros if there is any corruption.

4] Repair Microsoft Excel

If none of the above works, the problem might be with the Excel app. The application might be installed incorrectly or something needs to be repaired. So, repair Microsoft Excel using the below steps:

1. Launch Settings app and go to Apps > Apps & features.
2. On the right, locate and click Office 365/ Microsoft 365 program.
3. Tap on the Modify button and then select Online Repair or Quick Repair option.
4. Press the Repair button which repairs Excel and other Office apps.

5] Uninstall, and then reinstall Excel

You can also try to uninstall and then reinstall Office and Excel software to start afresh. See if this fixes up the error.

6] Some Other Methods

Also, some other solutions may also work like:

• You can try running an SFC scan to check and repair corrupted system files.
• Some malicious programs can also cause this error. So, check and remove malware and suspicious application with Microsoft Defender or third-party antivirus or antimalware program.
• Try deleting corrupted cache data and system junk files.

Hope the above solutions help!

Now read: How to Fix Runtime Error 1004 in Excel

Related posts

• Hagaha VBA Sare ee MS Excel

• Sida Loo Abuuro VBA Macro Ama Script gudaha Excel

• Sida loo isticmaalo Percentile.Exc function gudaha Excel

• Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel

• Sida loo tiriyo lambarka Haa ama Maya ee Excel

• Sida loo isticmaalo Rept Function gudaha Excel

• Sida loogu isticmaalo shaqada MID iyo MIDB gudaha Microsoft Excel

• Sida loo midoobo oo loo kala saaro unugyada Excel

• Sida loogu isticmaalo DEC2Bin gudaha Excel si loogu beddelo nambarka jajab tobanle ee binary

• Sida loo isticmaalo Muddada Dhaqaale Function gudaha Excel

• Sida waqti loogu daro ama loogu daro Microsoft Excel

• Sida loo isticmaalo DCOUNT iyo DCOUNTA Function gudaha Excel

• Sida loo abuuro Bracket tartanka gudaha Windows 11/10

• Khaladka Run-time 1004, Ma socodsiin karo Macro gudaha Excel

• Sida loo isticmaalo shaqada ISODD ee Excel

• Xisaabi leexashada caadiga ah iyo khaladka caadiga ah ee macnaha Excel

• Sida loo isticmaalo INT iyo Functions LCM gudaha Excel

• Sida loo tiriyo qiyamka nuqul ka mid ah tiirka Excel

• Sida loo isticmaalo shaqada Mode ee Excel

• Sida loo beddelo qaabka faylka caadiga ah ee lagu kaydiyo Word, Excel, PowerPoint