How to make cell not editable

  • Thread starter Thread starter basavaraj.janayi
  • Start date Start date
B

basavaraj.janayi

I have to make cell not editable depending upon the selection of
values from the combobox.I have done this using by locking the cells
but it's not good, can anybody tell how to do this in anotherway Thanks
 
Not good? Locking the cells (and protecting the sheet!!!) is the only way to
go. You would however need a macro to do what you want.

Joerg
 
You must log in or register to reply here.

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

hoW TO LOCK AND UNLOCK A CELL USING A FUNCTION/FORMULA 6
want to track time while paste value in multiple column of same roe 1
Multi worksheet protection & editing ability 6
Locked Cell - can still edit 2
How to Edit Lists 2
"Save As" to XML file macro using a cell's value 0
show a customised message when a trying to edit a locked cell 2
Special editing 1

Back
Top