All cells in a sheet are, by default left ready to be protected when the
sheet as a whole is protected.
1) Select the cells to be left unprotected.
2) Go "format cells"
3) Select the "Cell protection" tab.
4) To make the cells editable after the rest is protected, Uncheck the
box "protected"
5) If you are going to sell your work in creating the spreadsheet, you
may want to keep your formulas from being copied. For the cells in which
there formulas exist, leave those cells protected, and check the "Hide
Formula" box.
6) You can also choose to hide certain cells from printing,
independently from whether they are visible on screen.
7) You must then select the sheet(s) to be protected, then go "Tools"
and protect the sheets as a whole. This will require you to create a
password. If you are doing this many times, I suggest you keep a record
of the passwords in a password protected Calc workbook stored on a USB
memory stick, so that most of the time the file is physically
disconnected from your system or the internet.
8) Copyright/intellectual properties laws vary from country to
country. Therefore if you are selling your work, you will want to have a
contract from your clients first, which explicitly states in detail what
you are licensing to the client and what you are not.
A dispute could result if the client was expecting to have access to the
formulas and had not signed a contract to the contrary. Often a client
will tacitly (unspoken) have such expectations.
If you are in the U.S.A., it is possible that your work could also be
subject to export control laws of the U.S. Government, and before
exporting, you should contact them to be sure you are legal.
Best Regards,
Bruce Martin
Montreal, QC Canada
On 1/6/2011 22:25, . wrote:
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?
--
Best Regards, Bruce Martin
