Yadda ake kunna da kashe macros a cikin Excel

Tare da taimakon macros a cikin Excel, an saita umarni na musamman, godiya ga wanda zaku iya sarrafa wasu ayyuka kuma, ta haka, rage lokacin da ake kashewa akan aiki sosai. Koyaya, macros suna da rauni ga hare-haren hacker kuma suna da haɗari. Ya kamata a tuna cewa suna dauke da wata barazana, kuma maharan na iya cin gajiyar wannan. Dole ne a yanke shawara game da buƙatar amfani da su, ana kimanta kowane takamaiman lamari.

Misali, idan mai amfani bai da tabbas game da amincin daftarin aiki da aka buɗe, zai fi kyau a ƙi macro, tunda fayil ɗin yana iya ƙunsar lambar cutar. Masu haɓaka shirin suna la'akari da wannan gaskiyar kuma suna ba mai amfani zaɓi. Wannan shine dalilin da ya sa Excel yana da aiki don saita macro, ko maimakon haka, ayyukansu.

Kunna da kashe macros a cikin Developer tab

Nan da nan ya kamata a lura cewa yayin aiwatar da wannan aikin, wasu masu amfani na iya fuskantar matsaloli. Wannan shi ne saboda gaskiyar cewa an kashe shafin "Developer" ta tsohuwa kuma, da farko, kuna buƙatar kunna shi.

1. Danna-hagu akan menu na "File".
2. Sa'an nan, a kasan jerin zaɓuka, zaɓi abu "Zaɓuɓɓuka".
3. A cikin sigogin shirin, muna sha'awar abin "Ribbon Setup". Na gaba, duba akwatin kusa da shafin "Developer". Yanzu muna tabbatar da aikin ta danna maɓallin OK.

Bayan kammala waɗannan matakan, shafin Developer zai kunna. Yanzu zaku iya fara kunna macros.

1. Danna "Developer" tab. A kusurwar hagu za a sami sashin da ake buƙata, inda muke danna maɓallin "Macro Security" a cikin nau'i na alamar motsin rai.
2. A cikin saitunan saitunan da ke bayyana, zaku iya kunna duk macros lokaci guda. Don yin wannan, zaɓi zaɓi "Enable all macros" daga duk zaɓuɓɓukan da aka gabatar. Ta danna maɓallin "Ok", muna tabbatar da canje-canjen da aka yi kuma mu fita sigogi.Duk da haka, ya kamata ku kula da gaskiyar cewa masu haɓaka Microsoft ba su ba da shawarar zabar wannan zaɓi ba, saboda akwai yuwuwar gudanar da wani shiri mai haɗari wanda zai iya cutar da kwamfutarka. Don haka, lokacin yin wannan aikin, ku tuna cewa kuna yin aiki a cikin haɗarin ku da haɗarin ku.

Deactivating macros yana faruwa a cikin akwatin maganganu guda ɗaya. Koyaya, lokacin kashewa, za'a tuntuɓar mai amfani da zaɓuɓɓuka guda uku a lokaci ɗaya tare da matakan tsaro daban-daban.

Kamar yadda sunan ke nunawa, a cikin mafi ƙarancin zaɓi, duk macros waɗanda ke da sa hannun dijital za su yi aiki da kyau. Kuma a cikin zaɓuɓɓuka biyu na farko, za a kashe su gaba ɗaya. Bayan mun zaɓi zaɓi, za mu danna maɓallin OK.

Saita Macros a cikin Zaɓuɓɓukan Shirin

1. Muna zuwa menu na "Fayil", kuma zaɓi abu "Zaɓuɓɓuka" a ciki - kama da abu na farko a cikin misalin da aka tattauna a baya.
2. Amma yanzu, maimakon saitunan ribbon, zaɓi sashin "Cibiyar Amincewa". A cikin ɓangaren dama na taga, danna maɓallin "Trust Center Settings..."
3. A sakamakon haka, tsarin zai jagorance mu zuwa taga saitunan macro, wanda kuma aka buɗe lokacin yin aiki a cikin Developer tab. Na gaba, zaɓi zaɓin da muke buƙata kuma danna "Ok".

Kafa macros a cikin sigar farko na Excel

A cikin sigar farko na shirin, an kunna macros kuma an kashe su daban.

Alal misali, algorithm na ayyuka a cikin shirye-shirye na 2010 da ƙananan suna kama da haka, amma akwai wasu bambance-bambance a cikin shirin shirin.

Kuma don kunna ko kashe macros a cikin sigar 2007, kuna buƙatar danna gunkin Microsoft Office a kusurwar hagu na sama. Bayan haka, kuna buƙatar nemo sashin “Settings” a ƙasan shafin da ke buɗewa. Ta danna kan sashin "Saituna", za mu isa Cibiyar Amincewa. Na gaba, muna buƙatar Saitunan Cibiyar Amincewa kuma, a sakamakon haka, kai tsaye, saitunan macro da kansu.

Kammalawa

Ta hanyar kashe macros, masu haɓakawa suna ƙoƙarin kare masu amfani daga haɗarin haɗari. Koyaya, a wasu lokuta, har yanzu suna buƙatar kunna su. Dangane da nau'in shirin, har ma a cikin nau'in iri ɗaya, ana iya yin hakan daban. Amma ba tare da la'akari da hanyar da aka zaɓa ba, hanyar tana da sauƙi kuma baya buƙatar zurfin ilimi da ƙwarewa a cikin aiki tare da PC.