Making a cell uneditable
Posted by Geoff on May 26, 2000 4:46 AM
Using VBA, how do you make a cell uneditable? Like when someone clicks a checkbox, I want to disable certain cells on the excel sheet. Thanks.
Posted by Ivan Moala on May 26, 2000 3:02 PM
Hi Geoff
You could try unlocking the cells you want enabled
and then protect the sheet.(by default all cells are locked)
Or
Use DataEntryMode.
Have a look @ online help.
Ivan
