Locking cell in worksheet | Infragistics Forums

405

Locking cell in worksheet

Andrew Cronwright posted over 15 years ago

I've created the excel worksheet and saved it. What I need to do it lock certain cells in the worksheet. my code to lock the cells is: For col As Integer = 0 To mPrimaryKeyColumn.Length - 1 For Each row As WorksheetRow In theWorkSheet.Rows row.Cells(col).CellFormat.Locked = ExcelDefaultableBoolean.True Next Next theWorkSheet.Protected = True The problem is, is that "theWorkSheet.Protected = True" locks the whole worksheet. I have tried to set every single cell to "row.Cells(col).CellFormat.Locked = ExcelDefaultableBoolean.False" before protecting the worksheet, but with no success. In excel (2007), in the "Protect Sheet" options, there is a whole list of permission that you can allow users to do to locked worksheets. I need to allow the users to edit cells that are not locked. How? Please help.

44743

Mike Dour posted over 15 years ago in reply to Andrew Cronwright

The Excel assembly does not currently support password protecting the exported workbooks. You can submit a feature request for this: http://devcenter.infragistics.com/Protected/RequestFeature.aspx.
Cancel
Reply

Cancel
405

Offline Andrew Cronwright posted over 15 years ago in reply to Mike Dour

Thanks! I set the worksheet.locked = true as the first thing i do after creating it and it works fine.

Is there any way to put password protection on the worksheet? After creating the worksheet in code (and going to all the effort of locking cells etc) and saving it. All you need to do is open it in Excel and click "Unprotect worksheet" and all your hard work is lost. I can't seem to find a password property.
Cancel
Reply

Cancel
44743

Mike Dour posted over 15 years ago

All cells are Locked by default. You must set Locked to False and then set Protected to True on the worksheet. Then you will be able to edit only the cells which are not locked. Also, if you know all cells in a row or column should be unlocked, you can set the Locked property on the cell format of the row or column. If this is not working correctly, it may be a bug and you can submit the issue to the support group: http://ko.infragistics.com/gethelp.
Cancel
Reply

Cancel