Pfupiso: Chinyorwa chino chinokuudza zvese nezvekuchengetedzwa kwepassword yeprojekiti yeVBA. Chinobatsira kune avo vanoda kuti faira ravo reExcel rive rakachengeteka uye vasingade kuti vamwe vanhu vawane mukana vasina mvumo. Tichakurukurawo nezvemiganhu yekuchengetedzwa kwepassword.
Dzivirira maMacro ako eVBA neUyu Hunyengeri
Dambudziko: Handidi kuti chero munhu awane pepa rangu reExcel uye agadzirise kana kuchinja chero kodhi ye macro yakaiswa mariri. Ndingaitei?
Sei: Pane mhinduro iri nyore kwazvo yedambudziko riri pamusoro apa. Chengetedza password yako yeVBA muExcel kudzivirira shanduko dzisina mvumo (ona mifananidzo iri pazasi).
Izvi zvinoshandawo kune mamwe maapplication eMicrosoft Office akadai seAccess, Word, nezvimwewo.
Danho rekutanga. Vhura bhuku rebasa reMicrosoft Excel rine purojekiti yako yeVBA.
Danho rechipiri. Dzvanya Alt+F11 kuti uvhure hwindo reMicrosoft Visual Basic for Applications.
Kana kuti unogona kudzvanya bhatani rekuti “Developer” > “Visual Basic”.
Danho rechitatu. Muhwindo reMicrosoft Visual Basic for Applications rakavhurwa, enda ku "Tools" > "VBAProject Properties".
Danho rechina. Mubhokisi re "VBAProject" rinoonekwa, tinya pa "Protection" mukoramu yekurudyi wobva watarisa sarudzo ye "Lock project for viewing".
Zvino nyora pasiwedhi mubhokisi remashoko riri pazasi pesarudzo iyi woinyorazve kuti usimbise. Wobva wadzvanya "Zvakanaka" kuti uvhare.
Chengetedza password iyi iri pedyo! Uchaida kuti uvhure purojekiti yako yeExcel VBA.
Danho rechishanu. Iye zvino unogona kuvhara hwindo reMicrosoft Visual Basic for Applications. Mushure meizvozvo, tinya bhatani rekuti “Save” riri mukona yepamusoro kuruboshwe rweExcel. Wobva wavhara bhuku rebasa reExcel.
Ndizvozvo chete. Aya ndiwo mashandisiro aunoita password yepurojekiti yako yeVBA muExcel.
Tinokukurudzira kuti uvhurezve bhuku rebasa reExcel kuti uve nechokwadi chekuti chirongwa cheVBA chakachengetedzwa zvakanaka.
Kana uchida kuvhura purojekiti yako yeVBA, ingobvisa dziviriro yepassword wodzvanya "Save" zvakare kuti ugadzirise shanduko.
Kudzivirirwa kweVBA Password uye Miganhu Yayo
Kunyangwe kodhi yako yeVBA yakavharwa nepassword, pane zvimwe zvakaipa panzira iyi—Haikwanise kudzivirira vanhu kuti vasapinde muchirongwa chako vanoda zvechokwadi kuita izvozvo.
Mumwe munhu anogona kuramba achishandisa bhuku rako rebasa reExcel asingazive password. Semuenzaniso, Zvinobvisa mapassword eVBA inogona kubvisa faira rako uye kugadzirisa zvakare password yako. Kutsvaga nekukurumidza kucharatidza kuti kune maturusi akadaro akawanda aripo pamusika, ezvekutengeserana neemahara.
Ehe, kuchengetedza password kunobatsira zvikuru kune vanhu vazhinji vasingade shanduko dzisina mvumo kukodhi yavo. Zvisinei, unofanira kuziva nezvemiganhu yayo kana uri kuishandisa kuchengetedza ruzivo rwakakosha kana pfuma yepfungwa. Saka kuti uchengetedze kodhi yako yeVBA zvinobudirira muExcel, mhinduro yakanakisa ndeyekuishandura kuita faira reC/C++. Unogona kuwana dzimwe sarudzo dzakawanda dze kuchengetedza kodhi yako yeVBA kubva pane chinongedzo.
