|
楼主 |
发表于 2014-8-13 11:54
|
显示全部楼层
本帖最后由 feiaoli 于 2014-8-13 11:58 编辑
su45 发表于 2014-8-13 11:24
只有双击区域内的单元格才表示为要修改单元格,在你页代码区增加两段代码:前段代码是双击就出现撤销保护框 ...
非常感谢!!,已经满足了我的要求。但是可不可以把您的第一段代码改写成重新写入数据弹出 密码保护的对话框呢?再次感谢老师!!- Private Sub Worksheet_SelectionChange(ByVal Target As Range)
- Dim irow As Long, icol As Long
- irow = Target.Row
- icol = Target.Column
- If irow > 4 And irow < 28 Then '限定表格行
- If icol > 1 And icol < 13 Then '限定表格列
- Sheet1.Unprotect Password:="12345"
- If ActiveCell.Value <> "" Then
- Target.Locked = True
- Sheet1.Protect Password:="12345", AllowFiltering:=True
- End If
- End If
- End If
- End Sub
- Private Sub Worksheet_BeforeDoubleClick(ByVal T As Range, Cancel As Boolean) '双击就出现撤销保护框
- If T.Row > 4 And T.Row < 22 And T.Column > 1 And T.Column < 10 Then
- Sheet1.Unprotect ' Password:="12345"
- End If
- End Sub
- Private Sub Worksheet_Change(ByVal T As Range) '修改单元格后就保护起来
- If T.Row > 4 And T.Row < 22 And T.Column > 1 And T.Column < 10 Then
- Sheet1.Protect Password:="12345", AllowFiltering:=True
- End If
- End Sub
复制代码 |
|