Types of MS Excel passwords

  • by Nucleus Data Reovery
  • Published on 2/15/07
  • Article views: 536
Your Ad Here

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
  2. Password for Modifications
  3. VBA Modules
  4. Worksheet Password
  5. Workbook Password 

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:

  • Open the .xls document, which you want to password protect.
  • Select the Save As option from the File menu.
  • Click the Tools tab on the top of the Save As window and select the General Options option.
  • The Save Options window will be displayed, where you can enter the desired password in the Password to open text box.

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.

  • Open the .xls document, which you want to password protect.
  • Select the Save As option from the File menu.
  • Click the Tools tab on the top of the Save As window and select the General Options option.
  • The Save Options window will be displayed, where you can enter the desired password in the Password to modify text box.

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:

 

  • Select the VBA module and right-click the mouse button.
  • Select the VBA Project Properties option.
  • Click the Protection tab.
  • In this window, check the Lock project for viewing option and assign password in the Password to view project properties dialogue box.
  • Click OK.

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:

  • Click the Tools menu
  • Select the Protection > Protect Sheet option. The Protect Sheet window will be displayed.
  • Select amongst the number of options for your worksheet. (These options depend on the working version of MS Excel; I am working in MS Excel 2003)
  • After selecting the options you can assign password to the worksheet.

5.) Workbook Password:

Like Worksheets, excel workbooks can also be protected in the similar way of protecting worksheets.

  • Click the Tools menu
  • Select the Protection > Protect Workbook option. The Protect Workbook window will be displayed.
  • Select both or appropriate option from Structure and Windows and assign the password.

You can also try this:

  • Click the Tools menu.
  • Select the Protection > Protect and Share Workbook option. The Protect Shared Workbook window will be displayed. This enables you to share the workbook with track changes.
  • Check the Sharing with track changes option. This would activate the Password text box.
  • Assign password in the Password text box.

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. But if in case the MS Excel file gets corrupt, you can try the FREE demo version of Kernel Recovery for Excel , a corrupt excel file recovery software which easily recovers and repairs the damaged worksheets and extracts cell data, formulas, charts, images, hyperlinks etc. If the Excel repair software displays your lost data then you can purchase Full version of the excel file repair software.

The author is a technical writer for Nucleus Data Recovery, provider of the best data recovery software for Windows, Backup Recovery, Email Recovery, Database Recovery, Password Recovery and File Repair Utilities.

Bookmark it: Digg this! Add to Del.icio.us Furl this! Add to Stumbleupon Add to Facebook

Rate this article:

More Articles

  • How to repair PST files?
    Repair PST files and recover outlook emails. Know how can one successfully repair pst files and recover emails and other items from them.
  • Certified Ethical Hacker Training Courses
    Companies across the world are pulling out all stops to protect their networks from hackers. These networks contain business critical and confidential information and are made up of expensive hardware and software components which are vulnerable to hacking attacks. Read on to know more about hackers and how to protect your systems from them.
  • Types of Computer Security Threats
    Because the computer is used in so many ways than one nowadays, many crooks out to harm and gain from exploiting other individuals are finding more and more that a computer is an excellent platform to perform their crime.
  • How to Recover Deleted Files?
    Have you ever imagined the situation of deleting important documents, mp3, images from your windows recycle bin - and not even able to find out a solution to recover those important documents?
  • Importance of Data for Financial Institutions
    Imagine this scenario - A bank is up in flames and the workers are fleeing in terror. In the ensuing noise and confusion, a few people were seen running into the inferno. These people were neither fire fighters nor heroes out to rescue trapped children. They were the simple and dedicated IT staff of the bank running in to retrieve the data back up storage devices, which had been placed on site.
  • How to repair PST files?
    Repair PST files and recover outlook emails. Know how can one successfully repair pst files and recover emails and other items from them.
  • Cutting-edge Background File Shredders
    File Shredder? Again? Not this time, lets talk about new file shredder that will not require users activity, which will work in background and make the file deletion more secure, supporting even temporary and cached files.
  • How to Backup Mails and Address book in Outlook Express
    Working on Outlook Express and dont know how to save your important emails and contact addresses from getting corrupt? Here are simple steps, by following you can save your emails and contact info at a different location, CDRW or DVD.
  • Importance of Data Recovery Software
    Know the importance of data recovery software and data recovery services when you face the situations of data loss and its inaccessibility. The number of data recovery software present in the market enables you to retrieve your lost data and the data recovery services prove helpful in recovery of data in cases of major corruptions to your storage media.
  • How to Protect Data from Virus Attacks?
    Virus attacks can lead to heavy expenditures on y our pocket to recover your data back. You can prevent such attacks of viruses, ad ware, spy ware, trojans with some simple preventive measures which will definitely help you to save your precious data.
  • How to Straighten Out Your Tax Affairs in 2010
    Utter the word 'taxes' in front of people and you are sure hear a loud groan. Frankly, there are valid reasons behind this response: First of all, paying your taxes annually can be a financial burden, especially with the economic hard times which we are going through these days.
  • Benefits of Yoga - Redefining Life, Meditation and Exercise
    Yoga is a complete exercise for the mind, body and soul and it can give a person a change to know himself in a new light. Regular practice of Yoga has been known to reduce stress, increase concentration and also benefit one's overall health.
  • The Best Floral Perfumes
    Floral perfumes are considered the best perfumes all over the world. In fact the history of perfumes says that floral perfumes are the first perfume category of the world and thus popular also. Floral perfumes represent the essence of love and romance.
  • Coffee Gift Baskets
    Even a Coffee Bean or San Francisco Coffee outlet frequenter will not be able to master the art of appreciating true gourmet coffee unless they know the history and information about gourmet coffee.
  • Rent a car in Israel
    If you are already in Israel and wish to rent a car, then you can make a booking and tell the service to pick you up from wherever you are. The best part about car rental in Israel is that they are extremely flexible.
  • A History of Vintage Automobiles - From 1916 to 1924
    Before cars were around, people usually traveled distances using horse-drawn carriages. But as early as 1335 several bright minds have been trying to come up with a 'horseless carriage'.
  • Ecommerce Checkout - Make Them Register
    The world of ecommerce is expanding daily as more and more retailers take their business to the web in the hopes of attracting a percentage of those ever finicky web shoppers. As the amount of businesses open up ecommerce shops online, the amount of web development companies is also growing, offering ecommerce solutions for even the smallest of budgets. It is important that web developers understand the dynamics of the checkout process when discussing the options with the client.
  • 3 Rules to Follow in Your Logo Design
    When designing your own logo or getting it done by logo design professionals, ensure the following three basic rules and you will have a great and memorable corporate identity.
  • Common mistakes before starting a website
    If you want your website to be a big hit then you need to avoid some common mistakes before starting one. Here you have a list of pitfalls that are designed for beginner and for many established ones too. Check out the common mistakes that have to be avoided for sure!
  • Top 10 SEO secrets
    Today everyone wants to have better search engine result pages ranks. However only one can have the rank 1. Therefore you need to optimize constantly your websites and to have an edge over others you need to do something different and unique. Following are 10 rare tips/secrets which can help you get high search engine ranks.


The opinions expressed in the above articles are solely of the authors and the owners of Point Articles may or may not agree with them. Copyright (c) 2008 Point Articles. All rights reserved.