disable cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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 filter rows data based on background color of individual cells 1
Help to create a macro 2
Need to highlight cells in special order 0
Need help deleting data 2
Formula Audit mode active in one column only; cannot kill. 2
Excel If a Cell Contains a Certain Text (From Another Table) 0
Auto fit text in cell of a protected worksheet 3
Disabled cells 2

Back
Top