Select all the cells that you want to be editable. Click 'format / cells' (or press ctrl 1) select the 'protection' tab uncheck the 'Protected' box. click OK Click 'Tools / Protect document / Sheet' Save
tc ________________________________ From: . <pe...@aleksandrsolzhenitsyn.net> To: users@openoffice.org Sent: Thu, January 6, 2011 10:25:06 PM Subject: [users] Lock formulas from being changed in Calc? I want to lock specific cells with formulas in a sheet so that they can't be changed while the remainder of the sheet must be editable How is it done?