Password protect cells in excel how to#
Password protect cells in excel code#
Password protect cells in excel password#

You can lock or unlock the row / column using the StyleFlag struct. A row / column has a Style API that further contains a setCellLocked method.

It unlocks all the cells in the worksheet first and then locks the first row in it.

Password protect cells in excel how to#

The following example shows how to protect a row in the worksheet. This method takes two arguments: a Style object and StyleFlag struct which has all the members related to applied formatting. Here, we can make use of applyStyle() method of Row class to apply Style to a particular row in the worksheet. Protect a Row in the WorksheetĪspose.Cells allows you to easily lock any row in the worksheet.

You can use this method to lock or unlock the row / column. A row / column has a Style API that further contains a set Locked method. It unlocks all the cells in the worksheet first and then locks 3 cells (A1, B1, C1) in it. The following example exhibits how to protect a few cells in the worksheet. In this method, we use Aspose.Cells API only to do the task.

Password protect cells in excel password#

In the Protect Sheet dialog box, you have the option to specify a password and select the elements that you want users to be able to change. This unlocks all the cells on the worksheet Select the entire worksheet by clicking the Select All button (the gray rectangle directly above the row number for row 1 and to the left of column letter A).Ĭlick Cells on the Format menu, click the Protection tab, and then clear the Locked check box. This method applies to Microsoft Office Excel 97, 2000, 2002, 2003 and greater versions. The following points describe how to lock a few cells using MS Excel. All the cells in a worksheet are already initialized for locking, you may check this opening any excel file into MS Excel and click the Format | Cells… to show Format Cells dialog box and then click the Protection tab and see a check box labeled “Locked” is checked by default.įollowing are the two approaches to implement the task. If you want to lock some specific cells in the worksheet, you have to unlock all the other cells in the worksheet. There might be certain scenarios where you need to lock a few cells only in the worksheet. To work on the worksheet, unprotect the worksheet by selecting the Protection, then Unprotect Sheet from the Tools menu item as shown below.Įntering password to unprotect the worksheet Once you open the file and try to add some data to the worksheet, the following dialog is displayed:Ī dialog warning that a user can’t modify the worksheet

Password protect cells in excel code#

The example below shows how to protect a worksheet with a password.Īfter the above code is used to protect the worksheet, check the protection on the worksheet by opening it. User cannot modify anything on this worksheet The ProtectionType enumeration contains the following pre-defined protections types: Protection Types If the worksheet is not already protected then just pass a null.

Old Password, the old password, if the worksheet is already password protected.

New Password, the new password used to protect the worksheet.

Protection type is applied with the help of the ProtectionType enumeration.

Protection Type, the type of protection to apply on the worksheet.

The Protect method accepts the following parameters: The Worksheet class provides the Protect method that is used to apply protection to a worksheet. A worksheet is represented by the Worksheet class. The Workbook class contains a WorksheetCollection that allows to access each worksheet in an Excel file. Adding or Removing ProtectionĪspose.Cells provides a class, Workbook, that represents a Microsoft Excel file. It prevents the end user from modifying data, content and formatting in the worksheet. Generally, worksheet protection is suitable for presentation purposes. Protected worksheets don’t hide or protect sensitive data, so it’s different from file encryption. The general protection options in Microsoft Excel are: For example, they cannot input data, insert or delete rows or columns etc.

When a worksheet is protected, the actions a user can take are restricted.

Advanced Protection Settings Using Aspose.Cells.

Advanced Protection Settings Using Excel XP and Later Versions.

Advanced Protection Settings since Excel XP.

Unprotecting a Password Protected Worksheet.

Unprotecting a Simply Protected Worksheet.