1.去除Excl整個工作簿密碼的命令:
Sub 工作簿密碼破解()
ActiveWorkbook.Sheets.Copy
For Each sh In ActiveWorkbook.Sheets
sh.Visible=True
Next
End Sub
2.去除Excel工作表密碼的命令:
Sub密碼破解()
Dim pj As Worksheet
For Each pj In Worksheets
pj.Protect AllowFiltering:=True
pj.Unprotect
Next
End Sub
3.破 Excel開啟密碼的教程:https://www.freedidi.com/2684.html