With the Excel file open:
Click "File"
Choose "Save As"
In the Popup click "Tools"
Choose "General Options"
A new popup appears.
You have several options.
"Password to Open" Choose this to create a PW to be able to open the file
(encrypted)

"Password to Modify" Choose this to create a PW to be able to modify the
file. Prevents the original file from beingoverwritten.

Read Only Recommened just suggests to the user to open in read only.

Advanced button allows you to choose your encryption.

Hope this helps. You can also go to Tools|Options|Security






"Manikandan" wrote:

How can i protect a file by giving password? It should not open without
correct password. How can i do this?