Overview

What is Password Remover?

· Password remover is an add-in that will automatically remove certain types of passwords from a workbook – see below for information on what passwords the add-in can remove.

· There is four different elements in an Excel spreadsheet than can be protected with passwords:

1. Worksheets – a worksheet can be protected by clicking Tools->Protect->Protect Sheet.

2. Workbook – a workbook can be protected by clicking Tools->Protect->Protect Workbook.

3. File – the Excel file can be protected by clicking File->Save As->Tools->General Options (this method differs slightly according to Excel version)

4. VBA – the VBA project can be protected by clicking (from within the VBE) Tools->VBAProject Properties->Protection

This add-in will remove the first two types (i.e. worksheets and workbook) of password.

How to use Password Remover

1. Click Tools->Remove Passwords

2. The following dialog box will appear:

3. Check ‘Remove Workbook Password” to remove passwords and\or ‘Remove Worksheet Password(s)’ to remove worksheet password.

FAQ

Q. How does Password Remover work?

A. A brute force approach is used, taking advantage of well known weakness in the Excel cryptographic process.

Q. Does Password Remover crack all passwords?

A. Pretty much all passwords can be cracked.

Q. Is there any way to protect Excel worksheets so that they can’t be unprotected by 3^rd party add-ins such as this one?

A. No.