ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

«O护¤u§@ªí®É¥Îvba

«O护¤u§@ªí®É¥Îvba

¦pªGa1:a10«O护¤F ,¦³¤èªk¥Îvba  copy  b1:b3  ©ñ¤Ja1:a3  ¶Ü?
³Ì«áa1:a10 ³£¬O³Q«O护ªº.
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

¥»©«³Ì«á¥Ñ jackdream ©ó 2010-7-25 20:18 ½s¿è

1.¥H VBA ¥ý¸Ñ°£¤u§@ªí«OÅ@(ActiveSheet.Unprotect »yªk)
2.¼g¤J¸ê®Æ
3.¦A¶i¦æ¤u§@ªí«OÅ@(ActiveSheet.Protect »yªk)

TOP

¥»©«³Ì«á¥Ñ basarasy ©ó 2010-7-25 20:36 ½s¿è

¦^´_ 2# jackdream
ÁÂÁ¤j¤j.
¤£¹L­n¥´±K½X, ¥i¥H¤£¥´±K½Xor¦b vba¤º¤J©w±K½X¶Ü?
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¤£¹L­n¥´±K½X, ¥i¥H¤£¥´±K½Xor¦b vba¤º¤J©w±K½X¶Ü?


°²³]¤u§@ªí±K½X¬° 123
¸Ñ°£«OÅ@ ActiveSheet.Unprotect "123"
¶i¦æ«OÅ@ ActiveSheet.Protect "123"

TOP

        ÀR«ä¦Û¦b : ¹D¼w¬O´£ª@¦Û§Úªº©ú¿O¡A¤£¸Ó¬O¨þ¥¸§O¤HªºÃ@¤l¡C
ªð¦^¦Cªí ¤W¤@¥DÃD