excelblueprism

Locked Excel Cells Becoming Unlocked When Re Opened

I have a Blueprism process which is locking a column and protecting the worksheet. The cells are then locked. When the file is saved, closed and re opened the cells are no longer locked.

GetInstance(handle).Activecell.Locked = True
GetInstance(handle).ActiveSheet.Protect
Solution

  • Issue was I was using a CSV. Doesn't seem to work there but does in a standard Excel Workbook.