Hsieh

¦^´_ 1# yeh6712
thisworkbook¼Ò²Õ

1. Private Sub Workbook_BeforeClose(Cancel As Boolean)
   
2. Application.MoveAfterReturnDirection = xlDown
   
3. End Sub
   
4. 
   
5. Private Sub Workbook_Open()
   
6. Application.MoveAfterReturnDirection = xlToRight
   
7. With ActiveSheet
   
8. .ScrollArea = "A1:K100"
   
9. With .Range("A1:K100").Validation
   
10.         .Delete
    
11.         .Add Type:=xlValidateWholeNumber, AlertStyle:=xlValidAlertStop, _
    
12.         Operator:=xlBetween, Formula1:="1", Formula2:="9"
    
13. End With
    
14. End With
    
15. End Sub

½Æ»s¥N½X

¦sÀÉ«á­«·s¶}±ÒÀɮסA¦b·í«e§@¥Î¤¤ªº¤u§@ªí§Y¥i¦³¦¹­­¨î¥\¯à
­­¨î¿é¤J.rar (14.27 KB)

¤U¸ü¦¸¼Æ: 7

2013-1-11 00:08