shahrizal 0 Report post Posted August 15, 2006 cam ne nak protect data kau dalam row tapi dalam masa yang sama user boleh key in data sebabnya aku wat format markah kat sekolah cikgu2 yang buta komputer main delete je skali ngan dia punya formula jalan.jadi caranya aku nak slamatkan formula dia boleh key data TLG YER Quote Share this post Link to post Share on other sites
isfann 0 Report post Posted August 15, 2006 lock cell... Quote Share this post Link to post Share on other sites
AnNamir 60 Report post Posted August 15, 2006 detail sikit camana nak lock cell tu buleh tak? Aku pun tumpang sekaki soklan sedare kita ni... Quote Share this post Link to post Share on other sites
shahrizal 0 Report post Posted August 17, 2006 cuba kau terangkan sket maksud lock cell....aku x fahamtq Quote Share this post Link to post Share on other sites
Syeeikh 0 Report post Posted August 17, 2006 send fail excel kat aku dulu untuk aku tunjukkan jalannya. Quote Share this post Link to post Share on other sites
shahrizal 0 Report post Posted August 17, 2006 macam mana nak sent fail kat ko...aku tak tau...ko cuba la trang cam ner nak protect data akuaku nak insert contoh pun aku tak tahu nak buat cam nerk tq Quote Share this post Link to post Share on other sites
shahrizal 0 Report post Posted August 17, 2006 aku tak tau nak sent cam ner kat ko... ko terang kan lah sket kat cni...kot2 aku faham Quote Share this post Link to post Share on other sites
C-Fu 0 Report post Posted August 17, 2006 kalo takat lock cell pon, susah untuk tekan F1 dalam excel dan carik kat help then ako rase susah ko nak faham kalo explain kat sini Quote Share this post Link to post Share on other sites
anonymous 0 Report post Posted August 17, 2006 Jawapannya ada di sini:http://www.mrexcel.com/archive/Formatting/2917.html Quote Share this post Link to post Share on other sites
shahrizal 0 Report post Posted August 17, 2006 ble x explain lg...dah nak faham ni Quote Share this post Link to post Share on other sites
C-Fu 0 Report post Posted August 18, 2006 (edited) mane ade orang explain???????????????????"pandai" gile ko ek. dah nak paham, tapi tak reti2 nak tanye part mane lagi yang ko tak paham. Edited August 18, 2006 by C-Fu Quote Share this post Link to post Share on other sites
aku 0 Report post Posted August 18, 2006 ko highlight cell yang nak dilock (harap jangan tanya cemana nak highlight, sebab menurut kenyataan ni ->"sebabnya aku wat format markah kat sekolah cikgu2 yang buta komputer" - cikgu2 sekolah yang buta komputer )pastu carik kat menu satu2.. ada tertulis terang tang tang.. aku maleh nak bukak excel.. Quote Share this post Link to post Share on other sites
shahrizal 0 Report post Posted August 18, 2006 jangan marah bang..... aku dah try lock tapi dia lock satu sheet smua.... aku nak lock row aje cam ner Quote Share this post Link to post Share on other sites
dragonfirebreath 0 Report post Posted August 25, 2006 highlightjellaaaaa.............takan itu pon nak cakap!highlght kat row. dragje cursor kat row tu Quote Share this post Link to post Share on other sites
pinggan 1 Report post Posted August 25, 2006 kalau dia dah lock sheet tue....ko kena unlock dulu....sebab tue full lock dari sheet protection...ko-check satu2 kat menu tue...ada menu untuk protection..lepas tu ko dah unlock baru ko follow...step2 sifoo kat atas nie.. Quote Share this post Link to post Share on other sites