password before opening excel workbook

Posted on 2011-05-06
Last Modified: 2012-05-11

I received an excel file, when try to open it, it asked me for a password, which i have, i am able to open the file.
my question, how do i do that.
How can i add that type of security to my excel files.

I am able to lock cells, but i want to put a password, so when anybody tries to open it, it will request a password.

Please let me know.

Question by:titorober23
    LVL 23

    Accepted Solution

    When you go to save the file, you can designate the security options. In Excel , save the file and then (find and) click the Tools dropdown and choose General Options. Here you can set a password in the Password to open textbox.
    LVL 16

    Expert Comment

    Another option if you want a custom form to open...
    LVL 16

    Expert Comment

    If you are using Excel 2010 or 2007 -- navigate to the review tab of the ribbon and choose protect sheet or protect workbook

    Author Comment

    i was able to protect the workbook, now i have 5 sheets, one of those is hidden, only few people should be able to access it.
    right now only 2 who knows the sheet is hidden are able to unhide and see it, but that is not enough protection, I dont want to create another file just for this sheet, is there anyorther way to protect this sheet from been seen.
    I already protect it against modification, but i want to protect it aganinst visibuility to unauthorize users.
    LVL 50

    Expert Comment

    This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
    How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
    The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
    This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now