Establish the Unprotect Password - Excel VBA
Closed
jrheeder
Posts
1
Registration date
Monday July 26, 2010
Status
Member
Last seen
July 26, 2010
-
Jul 26, 2010 at 05:40 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 30, 2010 at 09:34 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 30, 2010 at 09:34 AM
Related:
- Establish the Unprotect Password - Excel VBA
- Facebook account hacked and password changed - Facebook Forum
- Number to words in excel without vba - Guide
- How to enable vba in excel - Guide
- Excel date format dd.mm.yyyy - Guide
- How to reset windows 10 password without logging in - Guide
1 reply
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
Jul 30, 2010 at 09:34 AM
Jul 30, 2010 at 09:34 AM
Try to unprotect sheet with one password, then check if the sheet was unprotected. For that you can use
if (ActiveSheet.ProtectContents) then
msgbox "this is a good password"
else
msgbox "this is not so good password"
end if
if (ActiveSheet.ProtectContents) then
msgbox "this is a good password"
else
msgbox "this is not so good password"
end if