Excel code unprotect all sheets in book


Worksheet.Unprotect method (Excel) 05/30/2019; 2 minutes to read +1; In this article. Removes protection from a sheet or workbook. This method has no effect if the sheet or workbook isn't protected. Syntax. expression.Unprotect (Password) expression A variable that represents a Worksheet object. Parameters I have around 25 worksheets in my workbook (Excel spreadsheet). Is there a way I can protect all the 25 worksheets in single click ? or this feature is not available and I will have to write a VBA code to accomplish this. I need very often to protect all sheets and unprotect all sheets and doing individually is time consuming Worksheet.Unprotect method (Excel) 05/30/2019; 2 minutes to read +1; In this article. Removes protection from a sheet or workbook. This method has no effect if the sheet or workbook isn't protected. Syntax. expression.Unprotect (Password) expression A variable that represents a Worksheet object. Parameters This is a great thing. I have a workbook with 18 or 19 sheets and I hate having to protect each and every one whenever I ned to make changes. Is it limited to 3 sheets? When I run the protect all sheets macro it ask for the password and then to confrim but when I go to unprotect it says incorrect password. The password I entered is 1.