We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How do I protect certain cells in a spreadsheet?

All cells in an Excel spreadsheet have a "Locked" property which determines if the cell will be editable when the worksheet is protected. All the cells are set to locked by default, so when a worksheet is protected all the cells in the worksheet get protected by default. However there is often a need to protect certain cells only in a worksheet, In this scenario, we would need to protect a worksheet and set the IsLocked property to false for the cells that you want the end user to edit even when the worksheet is protected.

C#

// Sample data

sheetOne.Range["A1:K20"].Text="Locked";

//A1:A10 will not be protected

sheetOne.Range["A1:A10"].CellStyle.Locked = false;

sheetOne.Range["A1:A10"].Text = "UnLocked";

sheetOne.Protect("syncfusion");

VB

' Sample data

sheetOne.Range["A1:K20"].Text="Locked"

' A1:A10 will not be protected.

sheetOne.Range["A1:A10"].CellStyle.Locked = false

sheetOne.Range["A1:A10"].Text = "UnLocked"

sheetOne.Protect("syncfusion")

Sample

http://www.syncfusion.com/downloads/support/directtrac/general/CellsProtection-298051623.zip

Article ID: Published Date: Last Revised Date: Platform: Control:
1859 04/30/2011 07/18/2014 Windows Forms XlsIO
Tags:
Did you find this information helpful?
Add Comment
You must log in to leave a comment

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon