Excel Password Types
Have you ever thought that you can assign and protect your MS Excel worksheets with five different measures? Here I explain the number of password protections provided by Microsoft Excel.
Have you ever wondered that there can be types of passwords just like types of files? Is it possible? Yes it is. MS Excel is equipped with five types of password locking with which you can protect your worksheets. This means you can secure your MS Excel worksheet with 5 different password security measures and prevent unauthorized access to the worksheet.
This article targets to those users who need to secure excel worksheets for various reasons. Beneficial for people in finance field as MS Excel is widely used tool by accountants, charted accountants, brokers, stenos and every other individual who need to store and display data in a hierarchical order.
The Excel password types are:
1.) Password to open the Worksheet:
You can assign passwords to the excel worksheets and prevent any individual from accessing it. To assign password to your .xls file:
If any unauthorized individual tries to open the worksheet, Microsoft Excel will ask to enter the password. If the password is incorrect the sheet will not open.
2.) Password for Modifications:
This option works similarly as the first one. As the password was assigned to open the excel worksheet, password to modify the excel worksheet can also be assigned in the similar way.
Only authorized individuals who know the password can modify the document otherwise he can only view the read-only copy of the password protected worksheet. This kind of protection helps to protect the document getting modified by other people, thus saving the original data which you had saved before leaving your desk.
3.) VBA Modules:
The excel worksheet can contain VBA modules with added macros in the file. This Visual Basic for Application module can also be password protected. To password protect, perform the following:
The VBA module is now protected with password and secure from any unauthorized use.
4.) Worksheet Password:
There can be several worksheets in a single .xls file like Sheet 1, Sheet 2 and so on. You can password protect them too. To assign password to any current worksheet perform the following:
5.) Workbook Password:
Like Worksheets, excel workbooks can also be protected in the similar way of protecting worksheets.
You can also try this:
This kind of password protection helps at the time of sharing the excel worksheets. This would restrict other user from making changes in the document and retains the track changes in the sheet.
As there are 5 different options to protect the excel worksheet with passwords, there can be times when you tend to forget or lose the assigned password or the excel document can get corrupt due to virus attacks, accidental deletions, power outages etc. There are many excel password recovery tools to recover the lost / forgotten passwords. These software tools can easily restore the forgotten passwords of excel files.
Source: Free Articles from ArticlesFactory.com
ABOUT THE AUTHOR
The author is a technical writer