asked on

password before opening excel workbook

Hi

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.

thanks
Roberto

ASKER CERTIFIED SOLUTION

yobri

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

carsRST

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

http://www.youtube.com/rstcomputer#p/a/u/0/E2xRf1hZKtY

Raymond Peng

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

titorober23

ASKER

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)

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