The password you supplied is not correct. Verify that the CAPS LOCK key is off and be sure to use the correct capitalization

[romeo16]

I can protect and unprotect sheet using VBA but I can't unprotect using the normal way of excel and I am providing the same password. any help please? below are the codes


Sheets("sheet1").Select
ActiveSheet.Unprotect Password = "protect20"


Sheets("sheet1").Select
ActiveSheet.protect Password="protect20", DrawingObjects:=True, Contents:=True, Scenarios:=True

 

[Norie]

It should be := instead of =

Sheets("sheet1").Unprotect Password:= "protect20"


Sheets("sheet1").Protect Password:="protect20", DrawingObjects:=True, Contents:=True, Scenarios:=True

 

[romeo16]

it should be := instead of =

sheets("sheet1").unprotect password:= "protect20"


sheets("sheet1").protect password:="protect20", drawingobjects:=true, contents:=true, scenarios:=true

solved!!! thanks