hi, i created a form. i need to lock spesific cells for editing. is it possible?
M Miri Feb 21, 2007 #1 hi, i created a form. i need to lock spesific cells for editing. is it possible?
B Bob Phillips Feb 21, 2007 #2 Yes. Select all cells (Ctrl-A) and unlock them all (Format>Cells>Protection, uncheck Lock) Select the cells to protect and Lock them Then Protect the sheet, Tools>Protection>Worksheet. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
Yes. Select all cells (Ctrl-A) and unlock them all (Format>Cells>Protection, uncheck Lock) Select the cells to protect and Lock them Then Protect the sheet, Tools>Protection>Worksheet. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
