Hi All,
I am creating an excel file using COM-Handle. In one of the worksheet I need to add few properties as below:
Protect this sheet with password ‘123’. It should be allowed to Selected locked cells, Select unlocked cells, Format Cells, Format Columns, Format Rows and Sort.
Can someone help me how it should be added.
I am creating an excel file using COM-Handle. In one of the worksheet I need to add few properties as below:
Protect this sheet with password ‘123’. It should be allowed to Selected locked cells, Select unlocked cells, Format Cells, Format Columns, Format Rows and Sort.
Can someone help me how it should be added.