Sorry, a typo in my first query (1),

"So now I am able to edit the values in those unlocked cells through VBA without unprotecting the sheet."

I meant that I was able to edit the values in those unlocked cells through EXCEL sheet (and not in VBA)

- Sham