How can i set a password on excel file?
like when i want to open file it require password and without password it does not show any content.
CA Manish K Dhoot (CA, B. Com, NCFM, CPCM) (5015 Points)
08 August 2009How can i set a password on excel file?
like when i want to open file it require password and without password it does not show any content.
kaustubh
(CA, CS , CFM)
(293 Points)
Replied 08 August 2009
open the excel sheet
press F12..
this will open the "save as" dialog box..
to the top right hand corner u wud get properties or genereal options.. set password from der...
set password both for modification as well as opening the doc..
CA Manish K Dhoot
(CA, B. Com, NCFM, CPCM)
(5015 Points)
Replied 08 August 2009
Thanx kaustubh for this valuable thing
s
(-)
(216 Points)
Replied 09 August 2009
Also, there are two passwords:
1. Password to open
2. Password to modify.
You can use both the passwords as per your need. ie if you want people to only VIEW your file and not edit it, you can use it accordingly.
CA Rashmi
(final cleared)
(680 Points)
Replied 09 August 2009
open d excel sheet
go to TOOLS > PROTECTION
dere u can protect only one sheet or the whole workbook
u cn define extent of protection also
hope it will help u out.....
CA CS CMA Srinivasan N
(ACA, ACS, CWA Inter)
(1172 Points)
Replied 09 August 2009
There is another easy way.
Go to Tools > Options and select the Security Tab. You will have a dialog box for setting password both for open and modify.
Then you can save the file.
Rgds
LIVE Form 10 B and Form 10BB: Handle Tax Audit Reports of Charitable Organizations(with recording)