ActiveWorkbook.Sheets("Sheet3").unprotect Range("P1")

If this post helps click Yes
---------------
Jacob Skaria


"Kashyap" wrote:

Hi, I was trying to lock and unlock sheet using macro and the password should
pick from a cell (P1) from the same sheet

can anyone help me with this?

Thanks..