$$Excel-Macros$$ Re: i want protect cell only in first row

2009-04-29 Thread Ashish Jain
Hi Ravinder, Protect First Row: Select the cells to be protected Right Click on them and Select Format Cells Click Protection tab, Check if Locked property is selected or not. It should be checked/selected. Unprotect Rest Rows: Now Select rest of the cells to be unprotected. Right Click on them

$$Excel-Macros$$ Re: i want protect cell only in first row

2009-04-29 Thread Aindril De
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