giving password to MSexcel file

India
January 6, 2009 8:29am CST
Hi!!! i gave password to protect a worksheet in my MSexcel file. BUt when i opened the excel file, it doesnt asking password..but if i try to save anything it is asking password...but friends i want to give password protection while opening a ms excel file. is it possible? plz help me.... Thanks in advance
2 responses
@sona22 (1430)
• India
6 Jan 09
I don't know how you have protect your xls documents. Please try in this way. After your task go to file - Save as - tols - General options - enter password to password to open and password to modify box - ok - [a new box will appear with a dialogue: reenter password to proceed] - enter password - ok - [a new dialogue will appear again.. reenter password to modify - enter the password again - ok. Your documents will now password protected. And none will be able to open the documents. Now if you want to allow all to see the documents but want to prevent him from writing ten you have to do it other wise. If you want to know it I shall inform you.
• India
7 Jan 09
thank you friend!!!! its working :)
• India
7 Jan 09
its working..... thanx yaar...
• India
7 Jan 09
hmm there r two optisn one is to make ti readonly w/ passowrd the other is to open w/ password whcih one do u want? happy lottin and have a nice day