Hi Ravinder, 1) Select the entire worksheet and then removed the "Locked" Property from the cell properties. 2) Select the cells you want to be locked and then reset the "Locked" Property from the cell properties. 3) Select protect sheet and put a password.
Regards, Andy On Thu, Apr 30, 2009 at 12:52 PM, Punj <rkp...@gmail.com> wrote: > > I want protect cell in first line only > > I want if i overwrite this black cells, it does not change. > > and changes in below all cells can be made. > help required. > > -- > Regards, > RAVINDER PUNJ > > > > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
