how to unprotect a sheet in excel for mac

Rick-click on Microsoft Excel Objects, select Insert, and select Module.

Unprotect A Sheet In Excel Password That You

Protecting an Excel worksheet involves creating a password that you need to enter if you want to make changes to the sheet.

The first is obviously typing the password and unprotecting the sheet.

But if youve forgotten the password or the person who locked it didnt give the password to you, you arent out of luck.

Unprotect an Excel Sheet with the Password The easiest way to unprotect an Excel sheet is if you know the password.

Unprotect an Excel Sheet with Google Sheets Forgetting or losing the password on a protected Excel worksheet can be scary.

Your first thought may be that youve completely lost all the data in the sheet.

The good news is that theres a creative workaround that allows you to unprotect an Excel sheet.

Open your Google Drive account, select New and select Google Sheet to open a new sheet.

In the Import file dialogue box, select Upload from the menu.

In the Import file window, select Replace spreadsheet and select Import Data.

This will import the protected Excel worksheet into your Google Sheets worksheet.

Except, now youll notice that the sheet is no longer protected.

Now that its unprotected, you can export the sheet back to Excel format again.

In the now unprotected Google Sheet, select File and Download as Select Microsoft Excel (.xlsx) Select Save As.

Now you have the same exact Excel sheet, but the protection is removed.

Unprotect an Excel Sheet with VBA If you dont have a Google Drive account, or youre looking for another approach to unprotect an Excel sheet from inside Excel, VBA is a great way to do it.

Depending how complex the password is, the script can take from 10 minutes up to hours to run.

Step 1: Save as Older Excel File The only limit on this method is that it only works on Excel worksheets in Excel 2010 or older.

This isnt a problem, so long as you save the protected worksheet to an older version.

For the format dropdown, select Excel 97-2003 (.xls).

Unprotect A Sheet In Excel Cracked And You

Its a pain to have to save to an older format, but the benefit is that once the VBA script is done, the password is cracked and you have access to the unlocked sheet.

If its not there, click File Options Customize Ribbon, switch Choose commands from to All Commands, and move Developer from the left menu to the right one.

In the Developer menu, select View Code from the Controls section of the ribbon.

How To Unprotect A Sheet In Excel For Mac