Establish the Unprotect Password - Excel VBA
Closed
jrheeder
rizvisa1
- Posts
- 1
- Registration date
- Monday July 26, 2010
- Status
- Member
- Last seen
- July 26, 2010
rizvisa1
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Related:
- Establish the Unprotect Password - Excel VBA
- Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Forum - Excel
- Cascading combo boxes excel vba userform - Guide
- How to compare two Excel sheets with varying data ✓ - Forum - Excel
- Macro to compare 2 sheets and copy differences ✓ - Forum - Excel
- Excel vba select case like - Guide
1 reply
rizvisa1
Jul 30, 2010 at 09:34 AM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
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