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

trainee

·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

register313

¦^´_ 1# trainee

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

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

trainee

¥ý·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

register313

¦^´_ 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)

¤U¸ü¦¸¼Æ: 83

2012-3-27 12:09

trainee

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

trainee

½Ð°Ý 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

Hsieh

¦^´_ 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

¤U¸ü (385.19 KB)

2012-3-28 10:55

trainee

¦^´_ 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

trainee

¦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

trainee

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