Hi Veeru,
Could you send us the excel sheet.
On 2/8/12, Veeru TOC wrote:
> Dear Team
>
> in excel file i know protect sheets but i need particular
> Cells put the code or protect how it possible
>
> VBA code also no problem
> --
>
>
>
>
>
> *Thanks&Regards*
>
> * *
>
> *
Dear Veeru,
Visit on below link
http://www.youtube.com/watch?v=hForkbT9vgs
http://oreilly.com/pub/h/1216
On Wed, Feb 8, 2012 at 10:47 PM, Veeru TOC wrote:
>
> Dear Team
>
> in excel file i know protect sheets but i need particular
> Cells put the code or protect how it possible
>
sir,
it;s not working sir
small example:
A B total 12 6 72 14 8 112 15 8 120
above columns i protect of cells 72,112,120 only how its possible
On Wed, Feb 8, 2012 at 10:51 PM, Sam Mathai Chacko wrote:
> select all the cells, right click, format cell, protection tab, unc
select all the cells, right click, format cell, protection tab, uncheck the
locked status
Now select only those cells that need to be protected, right click, format
cell, protection tab, now check the locked status
Finally, protect the sheet. now those cells cannot be editted.
Sam Mathai Chacko
