Monday, November 23, 2009

How to protect MS Excel file using password?

In Microsoft Excel, you can protect a single cell, group of cells on a worksheet or an entire workbook by applying password so that unauthorized person can not display as well as modify your document. You can apply two types of password.

Password to open the document:

If it is applied then you have to give the correct password to open the workbook. Otherwise you cannot open the workbook.

Password to modify the document:
If it is applied then you have to give the correct password to modify the workbook. Otherwise your workbook is opened but you cannot modify the workbook. It means that your workbook becomes read-only.

To apply a password to MS Excel document, follow the given steps:

First click on "Tools" menu and select the "Option" from drop down menu.
A windows dialog box will appear, here select the "Security" tab.

Enter first password in "Password to open" text box under "File encryption settings for this workbook" section and second password in "Password to modify" text box (if required) under" File sharing settings for the workbook" section then click "Ok" button of dialog box.

Microsoft Excel will open "Confirm Password" dialog box for the confirmation of passwords. The maximum length of password is 15 characters.

Re-enter the password to open and password to modify and click "Ok" button of Confirm Password dialog boxes one by one.
Now close the file and then reopen to test the password.

Internet Error Codes and Meaning

Sometime you are browsing the internet and trying to open any website, your e-mail and any FTP sites , but you see different error codes there. You should be familiar with these error codes. You can solve these problems if you are well-known with the meaning of error codes.

Error Codes Meaning

400 This is bad request error, First check you may be typing wrong URL name and server could not understand your request.

401 You are trying to open any unauthorized access site or page. Check your username and password if you are trying to open any webpage.

402 Payment Required Error

403 You are trying to open any forbidden page and you are blocked by that domain.

404 Here you are trying to open the webpage that was removed or re-named, also check the URL spelling.

408 This is time out error. you should send the request with in time that the server set for you.