Steps to Securely Password Protect an Microsoft Excel 2007 File: Follow the following simple steps to securely password protect an Excel file:
*Step 1:* Open the Microsoft Excel 2007 file which you would like to protect or restrict to open using a password. *Step 2:* Go to the *Review* tab of Microsoft Excel file and then click on *Protect Sheet* or *Protect Workbook*. *Step 3: *Following the above steps, a pop-up window will be appeared. Select your options and type in the desired password. Try to use a hard password which is long and difficult to hack like 47A%^hyI7QQ. Moreover, to remember the password, you may copy the password into a different workbook for safe keeping. Just putting the password, click on *OK *button and it will again asks you to re-enter the password and just type the same password again and click on *OK *button *Step 4: *Now it's time to password protect the entire workbook and to do this, simply click on the *File, *then choose *Save As* option. The file-save window will be appeared. Type the file name which is suitable for your excel file, then select the *Tools* drop down menu. From the Tools menu, select *General Options*. *Step 5: *Following the above steps, a pop-up window will be appeared where you can put the password for the opening the entire excel file. This option enables to password protect the entire workbook and prevent anyone else from opening it and viewing its contents or changing the entire document. Here, you can apply the same procedure to save the password to another text file or word file. And that's all. Following the above steps you can easily protect your Microsoft Excel 2007 documents easily to open by anyone or to edit the document by anyone. When you have finished the above steps, then closing the excel file, try to reopen the file. You will see that it asks you to a password. If you put the password correctly then you can easily access the file otherwise not. Thus your documents become secure from all. Hopefully, you have successfully done the above steps to protect the Microsoft Excel 2007 file and restrict the access of the file. Regards, Maries On Sat, Jan 8, 2011 at 11:31 AM, ankit varshney <ca.ankit.varsh...@gmail.com > wrote: > Please Help > > How to Protect a Excel sheet with password in MS 2007, so that no one > can open the file without password. > > Thanks > > > > -- > Ankit Varshney > 9716588239 > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
