MS EXCEL MEIN MACROS ENABLE KESE KARE
Agar aap Excel mein VBA codes ya Macros use karte hain, toh aksar aapko "Macros Disabled" ya VBA enable karne ki jhanjhat se bachne ke liye ,aap Excel mein macros ko permanently enable kar skte hain. Is blog mein hum seekhenge ki kaise sirf ek baar setting change karke aap hamesha ke liye problem ko solve kar sakte hain.
Excel mein Macros Enable karne ka Tarika
STEP 1:- Excel Options Open Karein
Sabse pehle apni Excel file open karein aur File tab par click karein.
STEP 2:- Ab aapko more ya Options ka button dikhega,us par click kare.
STEP 3:- Trust Center Setting mein Jayein
Options ki window khulne ke baad , left side panel mein sabse neeche Trust Center par click karein.
STEP 4:- Iske baad right side mein Trust Center Setting button par click karein.
STEP 5:- Ab ek nayi window open hogi. Yahan life side mein macro settings par click karein. Ab "Enable all macors" wala option select kare.
STEP 6:- Active X setting Update karein
Kai baar sirf macro enable karne se kaam nahi chalta . Isliye ACTIVE X SETTING par jayein aur "Enable all control without restriction" ko select karein. ise aapko koi problem nahi aayegi.
STEP 7:- File ko sahi Format mein Save Karein
Sirf setting change karna kaafi nahi hai . agar aap chahte hai ki aapka macro hmesha kaam kare to file save karte samay ye dhyan rakhein.
CONCLUSION
Is simple steps ko follow karke aap Excel mein macros ko permanently active rakh skte hain. Ise aapka workflow fast hoga aur baar baar errors nahi aayenge. agar aapko yeh post achi lagi to comment karke jarur bataye or hume follow karna na bhule.
0 Comments