Excellent! I appreciate your efforts.
Kamal Verma.
----- Original Message -----
From: "BHAWANI SHANKAR VERMA" <bsvermad...@gmail.com>
To: "access india" <accessindia@accessindia.org.in>
Sent: Saturday, July 03, 2010 7:00 PM
Subject: Re: [AI] excel protection
here is the solution, i tried.
1. open new worksheet.
2. select all by pressing ctrl+a.
3. press ctrl+1, and go to protection tab. uncheck the box lock cell.
press
ok to confirm your action.
4. finish your entire working with excel sheet.
5. go to those particular cells which you want to protect and lock them
individually, as unlocked earlier in point no.3.
6. open the tools>protect>protect worksheet. if you don't want to give
password, leave the password blank. leave
the next check box in checked status. press tab, now you will land on list
box. in this list use up and down arrow keys to move through check boxes.
the first check box "lock cells" and the second check box "unlock cells"
should be checked. press ok to confirm your action. you all done.
please take note that once a sheet is protected, user is allowed only to
jump in to the unlocked cells. even a screen reader user can not access
locked cells. but, sighted user can see it on screen. i tried these
settings
with office xp and 2003. i don't use office 2007, because i am able to
open
office 2007 files with office xp.
let me know the result, please.
----- Original Message -----
From: "Kamal Verma" <kamalve...@pnb.co.in>
To: <accessindia@accessindia.org.in>
Sent: Saturday, July 03, 2010 1:35 PM
Subject: [AI] excel protection
Hai everyone,
In Excel, I need to protect only a single cell. Please advise me any
solution.
Thanks.
Kamal Verma
DISCLAIMER:
The Information transmitted in this email is solely for the addressee. It
is confidential and may be legally privileged. Access to this email by
anyone else is unauthorized. Any disclosure, copying, distribution or any
action taken by anyone other than by the intended recipient is prohibited
and may be unlawful. If you are not the intended recipient then kindly
delete the mail from your system. Any opinion or views expressed in this
mail may not necessarily reflect that of Punjab National Bank. The bank
considers unencrypted email as an insecure mode of communication.
Voice your thoughts in the blog to discuss the Rights of persons with
disability bill at:
http://www.accessindia.org.in/harish/blog.htm
To unsubscribe send a message to accessindia-requ...@accessindia.org.in
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes,
please visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
Voice your thoughts in the blog to discuss the Rights of persons with
disability bill at:
http://www.accessindia.org.in/harish/blog.htm
To unsubscribe send a message to accessindia-requ...@accessindia.org.in
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes,
please visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
DISCLAIMER:
The Information transmitted in this email is solely for the addressee. It is confidential and may be legally privileged. Access to this email by anyone else is unauthorized. Any disclosure, copying, distribution or any action taken by anyone other than by the intended recipient is prohibited and may be unlawful. If you are not the intended recipient then kindly delete the mail from your system. Any opinion or views expressed in this mail may not necessarily reflect that of Punjab National Bank. The bank considers unencrypted email as an insecure mode of communication.
Voice your thoughts in the blog to discuss the Rights of persons with
disability bill at:
http://www.accessindia.org.in/harish/blog.htm
To unsubscribe send a message to accessindia-requ...@accessindia.org.in with
the subject unsubscribe.
To change your subscription to digest mode or make any other changes, please
visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
