Issue with Protect/Unprotect Macro

I use the following protect/unprotect Macros in all of my files that need to be edited by multiple users. They work like a charm, except for the most recent file I have been working on.

____________________________________________
Sub Protect()

'stops screen updating

Application.ScreenUpdating = False



'protects locked cells

For Each sht In ActiveWorkbook.Sheets
sht.Protect Password:="teslinoor", DrawingObjects:=False, Contents:=True, Scenarios:= _
True, AllowSorting:=True, AllowFiltering:=True, AllowUsingPivotTables:= _
True

Next
ActiveWorkbook.Protect Password:="teslinoor", Structure:=True


End Sub
_________________________________
Sub Unprotect()

'stops screen updating

Application.ScreenUpdating = False



'unprotects locked cells

For Each sht In ActiveWorkbook.Sheets
sht.Unprotect Password:="teslinoor"
Next
ActiveWorkbook.Unprotect Password:="teslinoor"

End Sub
____________________________________________

I keep getting the "Error 1004" Error that states, "The password you supplied is not correct. Verify that the CAPS LOCK key is off and be sure to use the correct capitalization."

I have ensured that CAPS LOCKS is off (and I have even tried it with it on) and I have been careful to use the same capitalization. Additionally, when locked, this file needs to remain sortable.

Any help would be apprecaited.

-JT

Sub Unprotect()

'stops screen updating

Application.ScreenUpdating = False



'unprotects locked cells

For Each sht In ActiveWorkbook.Sheets
sht.Unprotect Password:="teslinoor"
Next
ActiveWorkbook.Unprotect Password:="teslinoor"

End Sub

"sht.Unprotect Password:="teslinoor" is the error. I have even tried manually unprotecting the file by typing in nthe password from the protect macro, but that has failed as well. Now my file is locked and I unable to unlock it for further editions.

-JT

Yes, and the passowrd is not working for that either.

CAPS were not a factor in any of the manul locks; I did not manually lock the file at all. CAPS were only included on my last resort, failed manual unlock attempts.

jtal, your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

I did not issue an infraction due to the context and your intent. I agree that you were acting in good faith trying to answer the question. But rules are rules and so we don't want the code published on this forum.