Excel Tonotono - ki te whakaora te wā koe

I roto i te Excel, Word ko Power Point, ka taea e koe te hanga i tou ake rōpū, ka karanga tonotono. whakaaunoa ratou te mahia o te mahi ngā, ina kua ki tonu te tono koe ki te kuputuhi pūtau o te hoahoa taua, ki te whakauru huinga rite o tātai, me ētahi atu ranei I roto i te meka, te tonotono - hōtaka iti, rite hanga ratou lekooti e i roto i hōtuhi Visual Basic. Heoi, ara matara i te pūmanawa, te kaiwhakamahi e taea ngāwari te waihanga me te whakatika ratou.

Ko te tino whakamahia nuitia Excel-tonotono. Ki te to ratou awhina, ka taea e koe te waihanga tuhinga, ara tātaitai, hei tauira, ki te tātai i te pūtea marama o te kamupene.

record tonotono

Waihanga i te tonotono i roto i ngā huarahi e rua. Tuatahi - tuhituhi i te hōtuhi VB i te wahanga. Na te mahi i hötaka. Ko ohie te ara tuarua: ko reira e tika ana ki te whakauru i te lekooti o mahi katoa i roto i te kaiwhakamahara motuhake, me te tika kotahi ki te mahi i nga ngā tukanga e hiahia ana koe ki te whakaaunoa.

Kia whai whakaaro ano tatou e founga ki te tuhi tonotono i Excel 2007 te whakamahi i makrorekordera (tikanga tuarua). Ko nga taputapu e tika ana i roto i te ripa "Kaiwhakawhanake". Mai te mea maha te ripa taunoa kore kitea, me te tuatahi haere koe ki te taupānga Tautuhinga. Ki te mahi i tenei, whakatuwhera te pātene a tawhio ki te logo Microsoft, ka tīpako «Kōwhiringa Excel". Ko te "tautuhinga Whaiaro", "tautuhinga Basic ...", whakaturia te tohu ki te tūemi, te kawenga mō te whakaatu i te ripa hiahiatia.
Ki te hanga i te tonotono Excel hou, ka hiahia koe te whai ake:

• Pāwhiritia te "Developer"> "waehere"> "Tonotono Record".
• Tuhia ki raro te ingoa, i nei e waiho reira mārama e te tonotono e.
• Tīpakohia te tika pokatata papapātuhi mō te uru tere ki te tonotono (e kore e whai i te reira ki te tārua o koutou mau taviri wera pinepine whakamahia Windows, hei tauira, te CTRL + C / CTRL + V ).
• Rārangi o te "Tiaki ki ..." Ko kawenga mo te hōkai o te tonotono. Ki ki a koutou tonotono Excel mahi i roto i ngā tuhinga katoa i whakatuwheratia i runga i tenei rorohiko, tīpako i te kōwhiringa "Tohi Whaiaro".
• Whakakiia i te whakaahuatanga (whakarārangi mahi tuhia katoa).
• Hei tīmata te tuhi, pāwhiri "OK". ka puta He icon i roto i te kokonga o te mata.
• Te mahi i te mahi e tika ana ki te pūtau.
• Pāwhiritia "Kati Hopu" i roto i te ripa "kaiwhakawhanake"> "Code".

Tuhipoka: Ka taea e ngā tonotono Excel mahara tohutoro pūtau whanaunga tino ranei. Ki te kore koe i tīpako i te kōwhiringa e tika ana, i te tuhi i te tonotono, ka mahara e hiahia ana mahi ki te tono i te reira ki te pūtau tīpakohia koe. Ki te whai koe ki te mahi ki ngā pūtau rerekē, te whiriwhiri i te kōwhiringa e pā ana ki te hononga whanaunga.

Te mahi ki te tahua tono (ripa-whakawhitinga) me whakawhiti ki ētahi atu matapihi i roto i te kaiwhakamahara kore e e tuhia.

Tautuhinga haumarutanga

Ahakoa fakapapau'i e taea takitahi te tono whakahaere tonotono mo te waehere kino, e kore e tūtohu ana ki te tango i reira i te pūtake korewhirinaki. Hei tauira, te tiki rite-hanga i te Internet. Ka taea e koe te whakawhirinaki i te whakaaro o anti-huaketo, me ngā tonotono whakamahia i runga i ngā rorohiko maha i roto i te tari, e tūtohu ana ki te whakarato i te waitohu mamati.

Na roto i te taunoa, te whakamahi o ngā tonotono i roto i ngā tuhinga e te nuinga o monokia. Whakahohea taea tonotono Excel e, ki te haere koe ki te ripa "Kaiwhakawhanake" me te "waehere"> "Haumarutanga Tonotono"> "Tautuhinga Tonotono"> "Whakahohea katoa"> "OK." ka tango huringa pānga te wa i muri whakatuwhera koe i te kōnae.