Unprotect Excel File for Modification/Edit

Microsoft Excel is a great commercial  spreadsheet software created and distributed by Microsoft corp. for Windows and Mac OS for data calculation, macro programming(Visual Basic for Application), graphical tools. Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It stores your unlimited and any type data in cells(Crossing point of  columns and rows). The file in Microsoft Excel is called a Workbook. Microsoft Excel stores our data in workbook with password protection. We can protect Microsoft Excel Worksheet from unauthorized changes with the help of a password. Some times we download password protected excel files from internet. When we try to open that file we get a password prompt dialoagbox. We don’t know the password, so we can’t open that file. Some of them contain important formulas and functions that you don’t know, so you are trying to see that formulas and functions. Today i am going to teach a simple tricks “How to recover a password protected excel file and remove password automatically from the files”. For this, we do not need any extra software or external tool. We will use a Macro for password cracking. First we will hold ourselves for understanding various Microsoft Excel Password Protection types.

Read More