Thuto ena e akaretsa ho sebelisa moqapi oa macro ho hlahisa macro e bonolo ho Excel . Sekoto sa macro se sebetsa ka ho rekota lintho tsohle tse ka sehloohong le ho tobetsa mouse. Boholo bo bōpiloeng thutong ena bo tla sebelisa mekhoa e mengata ea ho etsa lifilimi ho sehlooho sa lipampiri .
Ho Excel 2007 le 2010, litaelo tsohle tse amanang le macro li fumaneha Setsing sa ts'ebetso ea konteraka . Hangata, tab ena e lokela ho kenngoa leboneng e le hore e fumane litaelo tse kholo. Lihlooho tse koetlisitsoeng ke thupelo ena li kenyelletsa:
- Ho eketsa Thabiso ea Developer
- Ho qala ho Excel macro rekoto
- Likgetho tsa macro tsa libaka tsa Excel
- Ho rekota macro
- Ho matha ho hoholo
- Phoso ea Macro / Ho hlophisa boholo
01 ea 06
Ho eketsa Thabiso ea Developer
- Tobetsa Fateng tab ea lane ho bula lifaele tsa menu.
- Tobetsa ho Dikgetho ho menu ho bula lebokose la boitsebiso la Excel .
- Tlanya ka khetho ea khetho kahare ea fensetere ho sheba likhetho tse fumanehang ka letsohong le letona la lebokose la lebokose.
- Tlas'a karolo e kholo ea Thabiso ea dikgetho, fensetere e hlahloba konteraka ea Moqapi .
- Tlanya OK.
- Moqapi oa konteraka o lokela ho bonahala hona joale ka lekarecheng la Excel 2010.
Ho eketsa Thabiso ea Tlhahiso-pele ho Excel 2007
- Ho Excel 2007, tobetsa konopo ea Office ho bula menu ea theoha.
- Tobetsa konopo ea Excel Options e ka tlaase ho menu ho bula lebokose la boitsebiso la Excel Options .
- Tobetsa ho khetho e tloaelehileng ka holimo ho fensetere ea letsoho le letšehali la lebokose le bulehileng la lebokoseng.
- Tobetsa Thabiso ea Bonaneli ba Bonts'a ka lebokose le letsohong le letona la lebokose le bulehileng la lebokoseng.
- Tlanya OK.
- Moqapi oa konteraka o lokela ho bonahala hona joale ka lekarecheng.
02 ea 06
Ho eketsa Lethathamo la Worksheet Sehlooho / Excel Macro Recorder
Pele re qala ho rekota lintho tse ngata, re lokela ho eketsa sehlooho sa lipampiri tseo re tla li etsa.
Kaha sehlooho sa leqephe ka leng hangata se ikhetha ho leqephe leo, ha re batle ho kenyelletsa sehlooho se seholo. Kahoo re tla e eketsa mosebetsing, pele o qala ho rekota.
- Tobetsa seleng ea A1 leqepheng la mosebetsi.
- Ngola sehlooho: Litsenyehelo tsa Mabenkeleng a Cookie ka June 2008 .
- Tobetsa konopo ea Kena lebokoseng.
Excel Macro Recorder
Tsela e bonolo ka ho fetisisa ea ho hlahisa ho hongata ho Excel ke ho sebelisa serekoto sa macro. Ho etsa joalo:
- Tlanya tabeng ea Baetapele.
- Tobetsa ho Rekoto ea Macro ka lithane ho bula lebokose la boitsebiso la Record Macro .
03 ea 06
Dikgetho tsa Dikgetho tsa Macro
Ho na le dikgetho tse 4 tseo u lokelang ho li tlatsa lebokoseng lena la lebokose:
- Lebitso la macro - fa lebitso la hau lebitso le hlalosang. Lebitso le tlameha ho qala ka lengolo le libaka tse sa lumelloa. Ke mangolo, linomoro le moelelo o ka tlaase o lumelloa.
- Ntho ea Shortcut - (ho ikhethela) tlatsa lengolo, nomoro, kapa litlhaku tse ling sebakeng se teng. Sena se tla o lumella hore o mathe ka macro ka ho boloka konopo ea CTRL le ho hatisa lengolo le khethiloeng lebokoseng.
- Boloka chelete e kholo
- Khetho:
- Buka ena ea buka
- E kholo e fumaneha feela faeleng ena.
- Buka e ncha ea mosebetsi
- Khetho ena e bula fono e ncha ea Excel. E kholo e fumaneha feela ho file ena e ncha.
- Buka ea botho e kholo.
- Khetho ena e baka faele e patehileng Personal.xls e bolokang macros ea hau mme e etsa hore e fumanehe ho uena li-file tsohle tsa Excel.
- Tlhaloso - (khetho) kenya tlhaloso ea macro.
Bakeng sa Thuto ena
- Beha likgetho lebokoseng la boitsebiso la Record Macro ho bapisa le ba setšoantšong ka holimo.
- U se ke ua tobetsa OK - leha ho le joalo - sheba mona ka tlase.
- Ho tobetsa konopo e nepahetseng lebokoseng la Dikro la Boitsebiso ba Macro ho qala ho rekota lintho tse ngata tseo u sa tsoa li tseba.
- Joalokaha ho boletsoe pejana, rekoto ea macro e sebetsa ka ho rekota lintho tsohle tse ka sehloohong le ho tobetsa konopo.
- Ho bopa li- format_titles macro ho akarelletsa ho khetha mefuta e mengata ea mefuta ka tlung ea lehae ea ribone le mouse ha 'mino oa macro o ntse o sebetsa.
- E-ea mohato o latelang pele u qala setšoantšo sa macro.
04 ea 06
Ho rekota Macro Steps
- Tobetsa konopo ea OK ho lebokose la Macro ea Boitsebiso ho qala mochine o moholo.
- Tobetsa Thabeng ea Lehae ea Ribbon.
- Totobatsa lisele tsa A1 ho F1 kahare ea mosebetsi.
- Tobetsa ho letšoao la ho kopanya le la bohareng ho kenya sehlooho pakeng tsa lisele tsa A1 le tsa F1.
- Tobetsa Letšoao la Letlalo la Tlatsa (le shebahala eka pente e ka ba) ho bula lenane la ho theola mebala e khotsofatsang.
- Khetha Blue, Accent 1 ho tsoa lethathamong ho fetola mmala o ka morao oa lisele tse khethiloeng hore li be seputsoa.
- Tobetsa Letšoao la Letoto la Font (ke lengolo le leholo "A") ho bula lenane la ho theola lebala la mebala.
- Khetha White ho lethathamong ho fetolela temana liseleng tse khethiloeng hore li soeu.
- Tobetsa ho Font Size icon (ka holimo ho setšoantšo se pente) ho bula lenane la ho theoha ha boholo ba fonte.
- Khetha 16 lethathamong ho fetola boholo ba temana meleng e khethiloeng ho lintlha tse 16.
- Tobetsa Thabeng ea konteraka ea lithane.
- Tobetsa konopo ea Stop Recording ka lithane ho emisa ho hopola ho hoholo.
- Ka nako ena, sehlooho sa hau sa mosebetsi se lokela ho tšoana le sehlooho se setšoantšong se ka holimo.
05 ea 06
Ho matha Macro
Ho tsamaisa ho hongata hoo u ho ngotseng:
- Tobetsa tabeng ea Sheet2 tlase ea spreadsheet .
- Tobetsa seleng ea A1 leqepheng la mosebetsi.
- Ngola sehlooho: Litsenyehelo tsa Mabenkeleng a Cookie bakeng sa July 2008 .
- Tobetsa konopo ea Kena lebokoseng.
- Tobetsa Thabeng ea konteraka ea lithane.
- Tobetsa konopo ea Macros lebopeng ho tlisa lebokose la lebokose la Macro ea View .
- Tlanya ka li- format_titles tse kholo ka lebitso la lifensetere tsa Macro .
- Tobetsa konopo ea Run .
- Mehato ea macro e lokela ho matha ka tsela e itekanetseng mme e sebelise mehato e tšoanang ea ho etsa mekhoa e sebelisitsoeng sehloohong sa letlapa la 1.
- Hona joale, sehlooho se leqepheng la 2 se lokela ho tšoana le sehlooho se leqepheng la 1.
06 ea 06
Litlōlo tsa Macro / Ho hlophisa Macro
Liphoso tsa Macro
Haeba sesebelisoa sa hau se sa ka sa etsa kamoo ho lebeletsoeng kateng, mokhoa o bonolo le o motle ka ho fetisisa ke ho latela mehato ea thupelo hape le ho ngola hape macro.
Ho hlophisa / Bohato ho Macro
An Excel macro e ngotsoe ka puo ea lenaneo la Visual Basic for Applications (VBA).
Ho tobetsa mohlomong ka Edit kapa Step ho likonopo lebokoseng la boemo la Macro ho qala mohlophisi oa VBA (sheba setšoantšo se ka holimo).
Ho sebelisa mohlophisi oa VBA le ho koahela puo ea lenaneo la VBA ho feta tekano ea thupelo ena.