If you've lost your protected worksheet password, you'll need a way to unprotect that Excel sheet and get access again. Here's how to recover that protected Excel sheet. > You cannot use this command in a protected sheet. > kindly suggest the procedure to execute the macro in a protected sheet. i > want to protect some cells in the sheet from being uptaion. VBA Code to Unlock a Locked Excel Sheet: If you have ever forgotten a password for one of your excel worksheets you know how frustrating that can be. The code used in this instruction is one of the simplest I've found. It will generate a usable code that will unlock your protected sheet.... Nov 23, 2018 · Method #2: Unprotect Excel Sheet Password with Dr.Excel . Worksheet protection is used to prevent your Excel data from unauthorized changing or editing, so, if you will find you won't be allowed to modify or edit a worksheet that has been password protected in MS Excel, you need to first remove the sheet protection. Autoexpand Table on Protected Sheet Excel. Hi, This post is not a help request, it's a method offered for those who need to have the defined table autoexpand functionalities on a protected sheet.