|
楼主 |
发表于 2017-4-5 11:30
|
显示全部楼层
非常感谢老师指导,已经解决!
- Sub CancelPwd()
- Dim WbName As Variant, i As Integer, MyWb As Workbook, j As Integer
- B = MsgBox("请选择是否保护工作表,Yes=保护,No=取消保护", vbYesNo)
- If B = 6 Then
- WbName = Application.GetOpenFilename _
- (Filefilter:="Excel,*.xls;*.xlsx;*.xlsm", _
- Title:="选择你要添加保护密码的excel——可以多选", MultiSelect:=True)
- If TypeName(WbName) = "Boolean" Then Exit Sub
- Application.ScreenUpdating = False
- For i = 1 To UBound(WbName)
- Set MyWb = Application.Workbooks.Open(Filename:=WbName(i))
- For j = 1 To MyWb.Worksheets.Count
- MyWb.Worksheets(j).Protect Password:=""
- Next j
- MyWb.Save
- MyWb.Close
- Set MyWb = Nothing
- Next i
- Application.ScreenUpdating = True
- Else
- WbName = Application.GetOpenFilename _
- (Filefilter:="Excel,*.xls;*.xlsx;*.xlsm", _
- Title:="选择你要删除保护密码的excel——可以多选", MultiSelect:=True)
- If TypeName(WbName) = "Boolean" Then Exit Sub
- Application.ScreenUpdating = False
- For i = 1 To UBound(WbName)
- Set MyWb = Application.Workbooks.Open(Filename:=WbName(i))
- For j = 1 To MyWb.Worksheets.Count
- MyWb.Worksheets(j).Unprotect Password:=""
- Next j
- MyWb.Save
- MyWb.Close
- Set MyWb = Nothing
- Next i
- Application.ScreenUpdating = True
- End If
- End Sub
复制代码
|
|