Hi all,
I have an issue that is already driving me crazy. Maybe you could help me with this one.
I can't get this to work even though I thought it is quite easy and straightforward:
If workbook is protected then unprotect
If worksheet is protected then unprotect
Problem is that for few of my worksheets that are not password protected, excel tries to unprotect them anyway and fails at it because password is incorrect (because they are not protected).
I would like to add that on normal protected sheet code works and unprotects it and run again skips through the worksheet as it should.
Have you ever encounter something like this?
Maybe there is a functionality enabled somewhere in my worksheet that causes .ProtectContents to be TRUE even though it is not protected? Where can I check something like this?
Maybe there is some problem with my code?
I can't give up on this!
I have an issue that is already driving me crazy. Maybe you could help me with this one.
I can't get this to work even though I thought it is quite easy and straightforward:
If workbook is protected then unprotect
If worksheet is protected then unprotect
What is the problem?If ActiveWorkbook.ProtectStructure = True Then
ActiveWorkbook.Unprotect ("pass1")
End If
For Each ws In ActiveWorkbook.Worksheets
If ws.ProtectContents = True Then
ws.Unprotect ("pass2")
End If
Next ws
Problem is that for few of my worksheets that are not password protected, excel tries to unprotect them anyway and fails at it because password is incorrect (because they are not protected).
I would like to add that on normal protected sheet code works and unprotects it and run again skips through the worksheet as it should.
Have you ever encounter something like this?
Maybe there is a functionality enabled somewhere in my worksheet that causes .ProtectContents to be TRUE even though it is not protected? Where can I check something like this?
Maybe there is some problem with my code?
I can't give up on this!