Note: To add a digital signature, you need a valid certificate from a certificate authority (CA). For more information, see Add or remove a digital signature in Office files. For more information, see Add or remove protection in your document, workbook, or presentation.ĭigital signature: You can add digital signatures to your Excel file. Restrict Access: If your organization has permissions set up using Information Rights Management (IRM), you can apply any of the available IRM permissions to your document. For more information, see Add or remove protection in your document, workbook, or presentation. Mark as Final: Use this option if you want to mark your Excel file as the final version and want to prevent any further changes by other users. For more information, see Protect an Excel file. Use this option when you need to give Read-only or edit access to different users.
#Get activex work on protected cell password#
Setting a password to open or modify a file: You specify a password to open or modify a file.
This prevents other users from opening the file. You have two choices here:įile encryption: When you choose this option, you specify a password and lock the Excel file. It simply prevents users from modifying locked cells within the worksheet.įollowing are the different options available for protecting your Excel data:įile-level: This refers to the ability to lock down your Excel file by specifying a password so that users can’t open or modify it. Worksheet level protection is not intended as a security feature. You should not assume that just because you protect a workbook or worksheet with a password that it is secure - you should always think twice before distributing Excel workbooks that could contain sensitive personal information like credit card numbers, Social Security Number, employee identification, to name a few. If you forget or lose your password, Microsoft can’t retrieve it for you.