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

複製代碼

存檔後重新開啟檔案，在當前作用中的工作表即可有此限制功能
限制輸入.rar (14.27 KB)

下載次數: 7

2013-1-11 00:08