Protect in VBA with password

[pilot]

As long as I'm asking, what's the code to protect and unprotect a sheet with a password?

Here it is without the pw.

ActiveSheet.Unprotect

ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True

 

[Juan Pablo González]

the Unprotect and Protect methods have an optional parameter, called password, which is a string.

ActiveSheet.Unprotect "Password"

 

[Qroozn]

ActiveSheet.Unprotect ("yourPassword")