VBA script not running with blocked cells (not the ones the vba script is using)

Originally Posted by davesexcel

Where are you unprotecting the sheet?

Search for "excel vba unprotect sheet"

I thought it was:

ws.Range(ws.Cells(I, 7), ws.Cells(I, 16)).Locked = False

But after using your searchterm I found this:

Sheets("Sheet1").Unprotect Password:="ADSBP"

Do I need only the 2nd one, or both?