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 know I can do the above by unlocking the sheet, changed the cell lock attributes and relocking for each entered number. I'm looking for a more elegant way. I would like to somehow enter a value in a single or multiple cells that would trigger the action. I could flag each cell as entered or have a way to lock all non zero cells after all entries.
What I need is conditional cell locking. Does it exist? -- Dennis Marks --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
