|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
- Private Sub Worksheet_Change(ByVal Target As Range)
- If Target.Count <> 1 Then Exit Sub
- If Target.Column <> 2 Or Target.Column <> 17 Then Exit Sub
- ActiveSheet.Unprotect Password:="tom"
- If Target.Column = 2 Then
- If Target.Value = "Finished" Then
- Target.Resize(1, 12).Locked = True
- Else
- Target.Resize(1, 12).Locked = False
- End If
- Else
- If Target.Value = "OK" Then
- Target.Offset(0, -2).Resize(1, 3).Locked = True
- Else
- Target.Offset(0, -2).Resize(1, 3).Locked = False
- End If
- End If
- ActiveSheet.Protect Password:="tom"
-
- End Sub
复制代码 |
|