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

¸Ñ°£¿ï¨úÀx¦s®æªº«OÅ@ (¤v¸Ñ¨M )

¸Ñ°£¿ï¨úÀx¦s®æªº«OÅ@ (¤v¸Ñ¨M )

¥»©«³Ì«á¥Ñ trainee ©ó 2012-3-29 09:34 ½s¿è

·s¤B¦A¦³°ÝÃD¡I
½Ð°Ý¥i¦³¤èªk¡A
¦b¥þ±i¤u§@ªí¨ü«OÅ@ªº±¡ªp¤U¡A
¥i§_¥u¸Ñ°£©Ò¿ï¨úÀx¦s®æªº«OÅ@¡A
¥H½s¿è¸ÓÀx¦s®æ¡I¡H

·Ð½Ð¦U¤j¤j½ç±Ð¡I

¥»©«³Ì«á¥Ñ trainee ©ó 2012-3-28 21:43 ½s¿è

Hsieh¡G

·s¤B¤w´¢ºN¨ì¸Ñ°£¤èªk¡A
¤ð»Ý¤j¤j¦A¶O¤ß¡I
§Ú´¢ºN±o¨Óªº¤èªk¬O¶}±Ò¦Û­q¤u¨ã¦C¡A
´z¿ï¥¨¶°¡A
µM«á¥H·Æ¹««ü¦V¦Û­q¥¨¶°«ö¶s¨Ã©Ô¨«§Y¥i¡C

TOP

¦hÁÂHsieh¤j¤j½ç±Ð¡A
§Ú¤w°Ñ¸Ô¤j¤jªº¤èªk¡A¥[¨ì·s¤Bªº¤å¥ó¡C
¦ý¦³¤@°ÝÃD¡A¸Ó¦Û­q¥¨¶°«ö¶s¡A
­Y­n§R°£¡AÀ³¦p¦ó³B²z¡I¡H
·Ð½Ð¦A«ü¾É¡I

TOP

¦^´_ 7# Hsieh

·s¤B¹J¨ì§x´b¡A¦A¦¸­n [hsieh] ¤j¤j¥X¤â«ü¾É¡A
¦b¦¹Á¹L¡I
·s¤B­nºCºC®ø¤Æ¡A§Æ±æ¯à¦A«×©ó«e½úªº«ü¾É¤U¡A
¦³©Ò±o着¡I

TOP

¦^´_ 6# trainee

¿ï¨ú°Ï°ì¸ÑÂê
  1. Sub Part_Protect()
  2. With ActiveSheet
  3. .Unprotect "12345"  
  4. .Cells.Locked = True
  5. Selection.Locked = False
  6. .Protect "12345"  '±K½X12345
  7. End With
  8. End Sub
½Æ»s¥N½X
play.gif
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

½Ð°Ý register313 ¤j¤j¡A
»Õ¤U©Ò½ç±Ðªº¤èªk¡A
¥u¬O¸Ñ°£a1-a10³o¤Q­ÓÀx¦s®æªº«OÅ@¡A
¨ä¥L¦P­¶ªºÀx¦s®æ¡A
¤´·Ó¨ü«OÅ@¡C

½Ð°Ý§Ú­Y¶·«ö»Ý­n¡A
©ó¤u§@ªíªº«D«ü©wÀx¦s®æ§@¥X­×§ï¡A
°£¥þ­¶¸Ñ°£«OÅ@¥~¡A
¥i§_¥H»Õ¤W©Ò½ç±Ðªº¤èªk¡A
¸Ñ°£©Ò¿ï©wªºÀx¦s®æ¡A
¦pc17¡AµM«á¦A¿ïb25¡A(«Da1-a10¤º)ªº«OÅ@¡I¡H

·s¤B·Ð½Ð¦A½ç±Ð¡I

TOP

·PÁ¦^ÂФνç±Ð¡I
·s¤B·|¦n¦n¾Ç²ß¡I

TOP

¦^´_ 3# trainee
  1. Private Sub UserForm_Initialize()
  2.   ToggleButton1.Caption = "Âê©w"
  3. End Sub
  4. Private Sub ToggleButton1_Click()
  5. If ToggleButton1.Value = True Then
  6.    ToggleButton1.Caption = "¸Ñ°£"
  7.    ActiveSheet.Unprotect
  8.    [A1:A10].Locked = False
  9.    ActiveSheet.Protect
  10. Else
  11.    ToggleButton1.Caption = "Âê©w"
  12.    ActiveSheet.Unprotect
  13.    Cells.Locked = True
  14.    ActiveSheet.Protect
  15. End If
  16. End Sub
½Æ»s¥N½X
Book1.rar (8.34 KB)

TOP

¥ý·PÁÂregister313¤j¤jªº½ç±Ð¡I

¦ý§Ú©Ò¤£À´¬O¦p¦ó§@¤@«ö¶s¡A
¤@«ö«á¡A
¨Ï­ì¥»¨ü«OÅ@ªºÀx¦s®æ¡A
¦b¦³»Ý­n§@¥X­×§ïªº±¡ªp¤U¡A
¤~ÂI¿ï¸Ñ°£«OÅ@¡A¥H¶i¦æ½s¿è¡C
¥B§¹¦¨«á¡Aªð¦^¨ü«OÅ@ªºª¬ºA¡I

TOP

¦^´_ 1# trainee

ÃD¥Ø:A1~A10¥i½s¿è,¨ä¾lÀx¦s®æ¤£¥i½s¿è

1.¿ï¨úA1~A10,®æ¦¡/Àx¦s®æ  «OÅ@  ¤£¤Ä¿ïÂê©w
2.¤u¨ã/«OÅ@/«OÅ@¤u§@ªí

TOP

        ÀR«ä¦Û¦b : §Ñ¥\¤£§Ñ¹L¡A§Ñ«è¤£§Ñ®¦¡C
ªð¦^¦Cªí ¤W¤@¥DÃD