Using Protect and Cell Locking

In This Topic

You can protect the workbook or sheet and lock cells in the control.

Cells can still be edited if the workbook Protect property is true and the worksheet Protect property is false.

Protecting the workbook and sheet prevents cells from being edited. If you wish to allow the user to edit specific cells, protect the sheet and unlock only the cells you want the user to edit.

Data can be copied from locked cells.

Using Code

The following example unlocks cells in a protected sheet with the Locked property.

CS	Copy Code
gcSpreadSheet1.Sheets[0].Cells[1, 1].Locked = false; gcSpreadSheet1.Sheets[0].Cells[1, 1].Text = "Locked"; gcSpreadSheet1.Sheets[0].Columns[3].Locked = false; gcSpreadSheet1.Sheets[0].Rows[5].Locked = false; gcSpreadSheet1.Protect = true; gcSpreadSheet1.Sheets[0].Protect = true; gcSpreadSheet1.Invalidate(); private void button1_Click(object sender, RoutedEventArgs e) { gcSpreadSheet1.Sheets[0].Cells[1, 1].ResetLocked(); gcSpreadSheet1.Invalidate(); }

Copy Code

gcSpreadSheet1.Sheets[0].Cells[1, 1].Locked = false;
gcSpreadSheet1.Sheets[0].Cells[1, 1].Text = "Locked";
gcSpreadSheet1.Sheets[0].Columns[3].Locked = false;
gcSpreadSheet1.Sheets[0].Rows[5].Locked = false;
gcSpreadSheet1.Protect = true;
gcSpreadSheet1.Sheets[0].Protect = true;
gcSpreadSheet1.Invalidate();
private void button1_Click(object sender, RoutedEventArgs e)
        {
gcSpreadSheet1.Sheets[0].Cells[1, 1].ResetLocked();
gcSpreadSheet1.Invalidate();
        }

VB.NET	Copy Code
GcSpreadSheet1.Sheets(0).Cells(1, 1).Locked = False GcSpreadSheet1.Sheets(0).Cells(1, 1).Text = "Locked" GcSpreadSheet1.Sheets(0).Columns(3).Locked = False GcSpreadSheet1.Sheets(0).Rows(5).Locked = False GcSpreadSheet1.Protect = True GcSpreadSheet1.Sheets(0).Protect = True GcSpreadSheet1.Invalidate() Private Sub Button1_Click(sender As System.Object, e As System.Windows.RoutedEventArgs) Handles Button1.Click GcSpreadSheet1.Sheets(0).Cells(1, 1).ResetLocked() GcSpreadSheet1.Invalidate() End Sub

VB.NET

Copy Code

GcSpreadSheet1.Sheets(0).Cells(1, 1).Locked = False
GcSpreadSheet1.Sheets(0).Cells(1, 1).Text = "Locked"
GcSpreadSheet1.Sheets(0).Columns(3).Locked = False
GcSpreadSheet1.Sheets(0).Rows(5).Locked = False
GcSpreadSheet1.Protect = True
GcSpreadSheet1.Sheets(0).Protect = True
GcSpreadSheet1.Invalidate()
Private Sub Button1_Click(sender As System.Object, e As System.Windows.RoutedEventArgs) Handles Button1.Click
GcSpreadSheet1.Sheets(0).Cells(1, 1).ResetLocked()
GcSpreadSheet1.Invalidate()
End Sub