VBA - Error "Run-time error '1004'; The Password you supplied is not correct. Verify that the caps lock key is off and be sure to use the correct capi

[venkat1426]

Hi
i tried this one..

i am getting error "Run-time error '1004';The Password you supplied is not correct. Verify that the caps lock key is off and be sure to use the correct capitalization"

I am using this code.

Sub Autpen()


Application.ScreenUpdating = False


For Each ws In Sheets


With ws


.Unprotect Password:="123"
.Protect Password:="123", UserInterfaceOnly:=True
ActiveSheet.Protect AllowFiltering:=True
.EnableOutlining = True
End With


Next ws


Application.ScreenUpdating = True


End Sub


can you please help me on this.

Thanks

 

[Paul Ked]

you have the wrong password in:

    .Unprotect Password:="123"

 

[venkat1426]

I changed many passwords.. i'am getting same error.

 

[Paul Ked]

if you can't remember the password you set, delete the worksheet/book and start again.

 

[RoryA]

You have two protect calls and you only supply a password in the first one.

 

[venkat1426]

Hi
Can you send me code.
Can you please help on this..