disable cells

G

Ganesh

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
 
S

Simon Shaw

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
 
Top