How to make Non Editable cells in OWC10?

B

Bhaams

Hi All,

Does anyone know how to make a cell non-editable in OWC10.SpreadSheet?

Thanks
Bhaams
 
R

rusty cranbrook

You can protect the entire sheet by opening the Commands and Options
dialog and on the Protection tab, check "Proctect Active Sheet".

To allow editing on a subset of cells, use the "Unlock" button to
enable selected cells. Then protect the entire sheet as above.
 
K

KC

You can 'protect' the cell, but you'll have to protect the
whole spreadsheet and set ranges to edit. I've had little
success with this. Good luck
 
A

Alvin Bruney

actually you can lock cells at the cell level. each cell contains a boolean
locked property. you will need to use this in conjunction with sheet
protection
 
B

Bhaams

Thanks everyone.it works.
Is there any way to suppress the alert box, which is popped up when we try
to enter data into a non editable column.?

Thanks
Bhaams
 
Top