Dadka qaarkiis waxay ka cabanayeen qaladka Runtime Excel 1004. Laga soo bilaabo bilawgii, qaladkan ayaa laga yaabaa inuu ka soo baxo dhibaato weyn, laakiin run ahaantii, waa wax ka badan wax kasta oo kale. Khaladka Run-time 1004^{(Run-time error 1004)} wuu dhici karaa haddii Excel uusan helin Microsoft Visual Basic for Applications  ( VBA ) ama Macros .

Waxaan u niraahnaa tan sababtoo ah qaladka runtime 1004 waa sahlan tahay in la hagaajiyo, sidaas darteed, dadku waa inaysan maskaxdooda ku waayin. Haa, waan fahamsanahay inay hoos u dhigayso socodkaaga shaqada, laakiin marka aad hesho fikrad ah sida wax loogu wareego, waad fiicnaan doontaa. Hadda, waa in la sheegaa in qof kasta oo la kulma qaladkan uusan heli doonin ikhtiyaarka ah inuu isticmaalo maktabadaha kheyraadka qaarkood. Intaa waxaa dheer, waxaa laga yaabaa inay jiraan dhibaatooyin waxqabadka iyo shilalka joogtada ah si looga dhigo isticmaalka Excel xitaa mid aad u adag.

Waa maxay qaladka Runtime 1004 ee Excel

Waayo-aragnimadayada, khaladku wuxuu u muuqdaa inta badan marka isticmaaluhu isku dayo inuu socodsiiyo MS Visual Basic for Applications Macro . Dhammaan wax walba waa nidaamka amniga si looga xiro MS VBA ee Excel , laakiin haddii isticmaaluhu uu go'aansado inuu siiyo marin u helka, ka dibna qalad runtime 1004 waxay u badan tahay inuu waligiis soo muuqan doono. Fariinta qaladku waxay yeelan kartaa kala duwanaansho badan, waxayna kala yihiin:

• Cilada Runtime^(Runtime) 1004: Qaladka codsiga-qeexay ama shay-qeexay
• Cilada Runtime^(Runtime) 1004: Habka koobiga ee Fasalka ^(Copy)Xaashida shaqada^{(Worksheet Class)} wuu fashilmay
• Khaladka 1004: Helitaanka barnaamijka ee Mashruuca Aasaasiga ah ee Visual Basic^{(Visual Basic Project)} lama la aamini karo

Hagaaji qaladka 1004 ee Excel

Waxa ugu horreeya ee lagaa doonayo halkan waa inaad furto Excel Options , taas oo fudud. Kaliya^(Just) fur Microsoft Excel , kadibna dhagsii File , halkaasna ka dooro Options .

Marka aad joogto aagga Ikhtiyaarada^(Options) , fadlan dhagsii Xarunta^{(Trusted Center)} la aamini karo , ka dib Settings Center Trust.^{(Trust Center Settings.)}

Isla markiiba qaybta Xulashada ^(Options)Aaminaada^(Trust) waa inay soo baxdaa. Halkaa, fadlan dooro Macro Settings .

Ugu dambeyntii, dhagsii Trust gelitaanka qaabka shayga mashruuca VBA^{(Trust access to the VBA project object model)} , ka dibna ku dhufo badhanka OK taasina waa taas.

Ka baadh malware

Si taxaddar leh, waxaa laga yaabaa inaad rabto inaad sidoo kale iska baarto malware, markaa iska hubi inaad shid iskaankaga ka-hortagga Malware oo samee iskaan joogto ah si aad u aragto haddii ay wax soo baxayaan. Haddii aysan waxba soo bixin, markaa waxaan soo jeedinaynaa in la sameeyo iskaanka fayraska buuxa si loo hubiyo in dhammaan ay wanaagsan yihiin.

Difaaca Microsoft^{(Microsoft Defender)} waa qalab fiican oo loogu talagalay shaqadan, laakiin haddii taasi aysan ku filneyn indhahaaga, markaa waxaan soo jeedineynaa isticmaalka iskaanka malware-ka bilaashka ah^{(free standalone malware scanner)} .

Run-time error 1004, Cannot run the Macro in Excel

Some people havе been complaіning about the Excel runtime error 1004. From the outset, this error may come off as a huge problem, but in truth, it is more of a distraction than anything else. Run-time error 1004 may occur if Excel does not get access to Microsoft Visual Basic for Applications (VBA) or Macros.

We say this because the runtime error 1004 is simple to fix, therefore, folks shouldn’t be losing their minds over it. Yes, we do understand that it slows your workflow, but once you get an idea of how to spin things around, you’ll be just fine. Now, it must be stated that anyone who faces this error will not have the option to use certain resource libraries. Furthermore, there might be performance problems and constant crashes to make using Excel even more difficult.

What is Runtime error 1004 in Excel

From our experience, the error appears mostly when the user tries to run MS Visual Basic for Applications Macro. The entire thing is a security procedure to lock MS VBA from Excel, but if the user decides to give it access, then runtime error 1004 will likely never appear. The error message could have multiple variations, and they are:

• Runtime error 1004: Application-defined or object-defined error
• Runtime error 1004: Copy method of Worksheet Class Failed
• Error 1004: Programmatic access to Visual Basic Project is not trusted

Fix Error 1004 in Excel

The first thing you will be required to here is to open Excel Options, which is easy. Just open Microsoft Excel, then click on File, and from there, select Options.

Once you’re in the Options area, please click on Trusted Center, then Trust Center Settings.

Right away the Trust Options section should appear. From there, please select Macro Settings.

Finally, click on Trust access to the VBA project object model, then hit the OK button and that’s it for that.

Scan for malware

As a matter of precaution, you may want to also scan for malware, so be sure to fire up your anti-malware scanner and perform a regular scan to see if anything pops up. If nothing comes up, then we suggest performing a full virus scan to make sure all is well.

Microsoft Defender is a great tool for this job, but if that’s not enough in your eyes, then we suggest using a free standalone malware scanner.

Related posts

• Sida loo Hagaajiyo #N/A Khaladaadka gudaha Foomamka Excel sida VLOOKUP

• Sida loo duubo Macro gudaha Excel

• Sida Loo Abuuro VBA Macro Ama Script gudaha Excel

• Daaqadaha ma xaqiijin karaan saxiixa dhijitaalka ah (Koodhka 52)

• Hagaaji kaydku waa qaab aan la garanayn ama khalad dhaawacmay

• Aqoonsiga Dhacdada 158 qalad - Diskiga isku midka ah ee GUIDs ee ku jira Windows 10

• MBR2GPT waxay ku guuldarraysatay inay awood u siiso kaydinta/soo celinta mudnaanta Windows 10

• Hagaaji Windows 10 Cusbooneysii Qaladka Rakiba 0x8007042B - 0x2000D

• Madax adag ayaa heshay fariin khaldan oo xog xun Windows 10

• Hagaaji aqoonsiga Event ID 7031 ama 7034 qalad marka isticmaaluhu uu baxo Windows 10 kumbuyuutarka

• Haah! Ma badbaadin karno midkaas - Windows Photos App

• Faylka install.wim aad buu u weyn yahay nidaamka faylka loo socdo

• Habkani waxa uu u baahan yahay warbaahin meesha laga saari karo - Qaladka dib u dejinta erayga sirta ah

• Hagaaji qaladka Codsiga 0xc0150004 gudaha Windows 11/10

• SFC way ku guuldareysatay inay dayactirto iyo DISM waxay tusinaysaa qaladka 0x800f081f gudaha Windows 10

• Barnaamijku ma bilaaban karo sababtoo ah AppVIsvSubsystems32.dll ayaa maqan

• Khaladka nidaamka 6118, Liiska adeegayaasha kooxdan shaqada lama heli karo

• Nidaamka qalliinka lama bootin karo sababtoo ah khaladaadka darawalka

• Cilada adeegga ciyaaraha 0x80073D26, 0x8007139F ama 0x00000001

• Hagaaji cilada soo galitaanka dukaanka Microsoft 0x801901f4 Windows 11/10