Hi Joshi, You can protect few cells. pls follow the below steps:
1. First select all cells in sheet(ctrl+A) and go to format cells(ctrl +1) - protection tab - untick the locked cells -ckick OK 2. Now go to worksheet and select which cells you want protect - again go to format cells- protection tab - check the locked cells - click ok 3. Now the selected cells are locked. Go to Tools - protection-protect sheet- check the protect sheet(1st option)and check only the unlocked cells - give password - confirm the pass word- click OK. I hope this will work. Let me know if u need further help. Its just a reverse function. Regards, Vinu. On Nov 25, 9:46 am, "vaibhav joshi" <[EMAIL PROTECTED]> wrote: > hello everybody > > is it possible to keep few cell in a woksheet protected with password > without alteration of that particular cell,because i dont want to protect > entire sheet with password > > pls revert on the same > > Regards > > VAibhav Joshi --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "MS Excel & VBA Macros" group. To post to this group, send email to excel-macros@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en -~----------~----~----~----~------~----~------~--~---
