[Last Call] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 311
  • Last Modified:

password before opening excel workbook


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.

1 Solution
Brian GeeCommented:
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.
Another option if you want a custom form to open...

Raymond PengSystems EngineerCommented:
If you are using Excel 2010 or 2007 -- navigate to the review tab of the ribbon and choose protect sheet or protect workbook
titorober23Author Commented:
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.
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Tackle projects and never again get stuck behind a technical roadblock.
Join Now