破解Excel工作表保护密码

Sub 密码破解()
  ActiveSheet.Protect DrawingObjects:=True, CONTENTS:=True, AllowFiltering:=True
  ActiveSheet.Protect DrawingObjects:=False, CONTENTS:=True, AllowFiltering:=True
  ActiveSheet.Unprotect
End Sub

posted @ 2019-11-14 10:54  Dream1699  阅读(260)  评论(0编辑  收藏  举报