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.
6 Replies
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
Recent Topics
- NRO Interest - Taxed at source and in Foreign Coun
- Clarity needed on effective date
- Income Tax Refund Deadline Shortened to Five Years
- Rectification Applications for Past GST Demands
- Where can I find a trusted provider to hire a skip
- GST Invoices Series
- FILING OF ITR AY 20-21
- CLAIMING OF U CLAIMED RCM
- Building construction works
- REGARDING GSTR-9 F.Y 2023-24
Related Threads
CAclubindia
