how to make excel sheet password protected

True allows the user to delete columns on the protected worksheet, where every cell in the column to be deleted is unlocked. True allows the user to insert hyperlinks on the protected worksheet. True allows the user to insert rows on the protected worksheet.

True allows the user to insert columns on the protected worksheet. True allows the user to format any row on a protected worksheet. True allows the user to format any column on a protected worksheet. True allows the user to format any cell on a protected worksheet. If this argument is omitted, protection applies both to macros and to the user interface. True to protect the user interface, but not macros. This argument is valid only for worksheets. For a worksheet, this protects the locked cells. For a chart, this protects the entire chart. Store the passwords that you write down in a secure place away from the information that they help protect. If you forget your password, Microsoft cannot retrieve it. It's critical that you remember your password.

A pass phrase that uses 14 or more characters is better. Passwords should be 8 or more characters in length. Use strong passwords that combine uppercase and lowercase letters, numbers, and symbols. If you forget the password, you cannot unprotect the worksheet or workbook. Otherwise, you must specify the password to unprotect the worksheet or workbook. If this argument is omitted, you can unprotect the worksheet or workbook without using a password. Parameters NameĪ string that specifies a case-sensitive password for the worksheet or workbook. Protect ( Password, DrawingObjects, Contents, Scenarios, UserInterfaceOnly, AllowFormattingCells, AllowFormattingColumns, AllowFormattingRows, AllowInsertingColumns, AllowInsertingRows, AllowInsertingHyperlinks, AllowDeletingColumns, AllowDeletingRows, AllowSorting, AllowFiltering, AllowUsingPivotTables)Įxpression A variable that represents a Worksheet object. Protects a worksheet so that it cannot be modified.

How to make excel sheet password protected