And then reprotect it with a password using the code you have seen above. If a sheet protected without a password, and now you want to protect it with a password, you need to unprotect it first.So, make sure to write down your password somewhere in a safe place. If you forget your password, Microsoft cannot retrieve it.Make sure to use strong passwords that combine uppercase and lowercase letters, numbers, and symbols.AllowUsingPivotTables: To let the user use a pivot table.

AllowFiltering: To allow filtering columns.Allow Sorting: To allow the user to sort rows, columns, and tables.AllowDeletingRows: To allow the user to delete rows.AllowDeletingColumns: To allow the user to delete columns.AllowInsertingHyperlinks: To allow the user to create hyperlinks.AllowInsertingRows: To allow the user to insert new rows.AllowInsertingColumns: To allow the user to insert new columns.AllowFormattingRows: To allow the user to apply formatting to rows.AllowFormattingColumns: To allow the user to apply formatting to columns.AllowFormattingCells: To allow the user to apply formatting to cells.UserInterfaceOnly: To only protect the user interface not macros.Scenarios: To protect scenarios in the worksheet.Contents: TO protect cells that are locked and the entire chart.DrawingObjects: To protect and unprotect shapes.

expression.Protect (Password, DrawingObjects, Contents, Scenarios, UserInterfaceOnly, AllowFormattingCells, AllowFormattingColumns, AllowFormattingRows, AllowInsertingColumns, AllowInsertingRows, AllowInsertingHyperlinks, AllowDeletingColumns, AllowDeletingRows, AllowSorting, AllowFiltering, AllowUsingPivotTables) Other Things to KnowĪs I said, we are using VBA’s “Protect” method, and there are arguments other than “Password” with this method that you can use. There’s one thing that you need to take care, take care of capital letter as VBA differentiate between capital and small letters. Sheets('Sheet1').Unprotect Password:='ADSBP' Let’s say the password that you have used to protect the sheet is “ADSBP” so the code to unprotect it would be like below. In the same way, if you want to unprotect a sheet, you need to mention the password in the password argument. Sheets('Sheet1').Protect Password:='test123' Unprotect a Sheet with Password

Cara unprotect sheet excel