Hi Dennis, On Mon, Jan 09, 2006 at 17:22:58 -0800, Dennis Marks wrote:
> What I need is conditional cell locking. Does it exist? No, you could apply a macro that locks all non-empty cells within a range. > I have a sudoku solver that I am trying to modify. After the original set of > numbers are entered into the grid I would like to have a way to lock all of > the cells that contain numbers so that they can't be modified by mistake as > surrounding numbers are entered. I suggest to use two cell styles, one with protection off, and the other one with protection on. From the Stylist apply the non-protected style to the entire area in question. When done with entering the numbers do a multi-selection of all value cells and apply the protected style. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. GnuPG key 0x293C05FD: 997A 4C60 CE41 0149 0DB3 9E96 2F1A D073 293C 05FD --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
