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. (Last updated on: November 16, 2018).
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 WinForms XlsIO
Tags:
Did you find this information helpful?
Add Comment
You must log in to leave a comment

Please sign in to access our KB

or the page will be automatically redirected to sign-in page in 10 seconds.

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