I have a simple prosess.
I read range using Read Range UiPath.Excel.Activities.ReadRange, to a datatable with protected format(not able to select locked cells).
Then I add a few rows to this datatable, and then append the datatable to a different workbook (also protected without ability to select locked cells.
My issue is that the protection settings of the sheet in the workbook have changed after appending the datatable rows. And so the user is now able to select locked cells.
This is my sheet protections before appending:
And after appending another user is allowed to edit locked cells:
Sequence.xaml (5.5 KB)