[AI] excel protection

Kamal Verma kamalverma at pnb.co.in
Mon Jul 5 02:42:43 EDT 2010


Excellent! I appreciate your efforts.

Kamal Verma.
----- Original Message ----- 
From: "BHAWANI SHANKAR VERMA" <bsvermadurg at gmail.com>
To: "access india" <accessindia at 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" <kamalverma at pnb.co.in>
> To: <accessindia at 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-request at 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-request at 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. 




More information about the AccessIndia mailing list