Hi,
I want to make certain cells non-editable in the sheet. I am using the following code:
DestinationSheet.Cells.Locked = False
DestinationSheet.Range("N13:N52").Locked = True
DestinationSheet.Protect
But this is making the sheet protected and I cannot do further operations on the sheet. Is there a workaround?
Thanks for your help.