Thread: disable cells
View Single Post
  #2   Report Post  
Simon Shaw
 
Posts: n/a
Default

Something I have used in the past (although not as secure as protection -
which is also not all that secure) is to use cell validation, set the Allow:
to Custom, then in the formula enter < this essencially does not allow any
data entry to a cell, unless of course the validation is removed.

Simon

"Ganesh" wrote:

Hi There,
I just want to know how to disable certain cell/column/row in an excel sheet
without using protect sheet option.
I have Microsoft Offices 2000 installed on my PC.

Thanking in advance
Gaensh