View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
[email protected] kthprog@gmail.com is offline
external usenet poster
 
Posts: 7
Default Password Cracker for Excel Worksheets/ Workbooks

For Each wb In Worksheets
wb.Unprotect a & b & c & d & e & f & g & h & i & j & k & l
If wb.ProtectContents Then: wsFound = False
Next

you have to add this into the worksheets loop for it to find all worksheet passwords