Protect and UnProtect Worksheets in Excel VBA if you want to restrict the users to not to modify the structure of the worksheet. ... Reasons for protecting a sheet ... If you see there is a message "One or more sheets in this workbook have been locked to prevent unwanted changes to the data", click Unprotect button after it. Type modify password you know in Unprotect Sheet dialog, and click OK. At this moment, you have successfully removed Excel 2016 open and modify password protection if you see following ... Hello Friends, This is a small VBA code to help you in dealing with Protecting and UnProtecting the WorkSheet using Excel Macro. Assuming the fact here that you know How to Protect or UnProtect a Sheet using Excel In-Built function .

Jun 10, 2013 · Unprotect Password Protected Sheet in Seconds In case of a password protect worksheet you are unable to Edit the data on the Excel Sheet. If you do not Remember the Password or do not know the password to unprotect the sheet just follow the below simple steps. Method 1: Unprotect Excel Sheet with Password. If you know the password for the protected sheet, removing protection is a matter of seconds. Here's how: Open the Excel file (.XLSX, .XLS) in Office Excel. Right-click on a protected worksheet tab at the bottom of your screen, and then select Unprotect Sheet.