輕鬆去除Excel密碼,工作表、工作簿也可以

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