D Dave Peterson Aug 18, 2006 #2 You can lock or unlock any cell (format|cells|protection tab) And when you protect the worksheet (Tools|Protection|Protect sheet), the locked cells won't be able to be changed by the user. But this worksheet protection is easily broken. So it's not made to protect intellectual property. And there are lots of things that can't be done to a protected worksheet, you'll want to test it to see if you're happy.
You can lock or unlock any cell (format|cells|protection tab) And when you protect the worksheet (Tools|Protection|Protect sheet), the locked cells won't be able to be changed by the user. But this worksheet protection is easily broken. So it's not made to protect intellectual property. And there are lots of things that can't be done to a protected worksheet, you'll want to test it to see if you're happy.
G Gord Dibben Aug 18, 2006 #3 Ann By default all cells on a sheet are locked when the sheet is protected. CTRL + a(twice in 2003) to select all cells. Format>Cells>Protection. Uncheck "locked" and OK Now select the sections/rows/cells to protect and Format>Cells>Protection. Check "locked" and OK Tools>Protection>Protect Sheet The section/row locking does not work if you don't protect the sheet. Gord Dibben MS Excel MVP Is it possible to write-protect ONE cell at a time? Thank you Ann Click to expand... Gord Dibben MS Excel MVP
Ann By default all cells on a sheet are locked when the sheet is protected. CTRL + a(twice in 2003) to select all cells. Format>Cells>Protection. Uncheck "locked" and OK Now select the sections/rows/cells to protect and Format>Cells>Protection. Check "locked" and OK Tools>Protection>Protect Sheet The section/row locking does not work if you don't protect the sheet. Gord Dibben MS Excel MVP Is it possible to write-protect ONE cell at a time? Thank you Ann Click to expand... Gord Dibben MS Excel MVP
