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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
how to delete rows in OWC10 spreadsheet? 1
Why OWC10 chart binding to the spreadsheet doesn't work? 3
How to Justify a cell in OWC10 8
Visio: copy text of a master shape to User-define Cells (Variable) 0
How to delete columns in OWC10? 2
Install OWC10 (URGENT) 1
owc10 & owc11 2

Top