View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Athens Athens is offline
external usenet poster
 
Posts: 1
Default Code to disable a cell in excel

Ok i've looked all over but i am new to excel and don't know how to change
the advice people have given to others to suit my own purposes.

So my question..

I am making a spreadsheet form that people are going to be filling out using
both text and numbers.

Most of the sheet will be unlock, but i want certain cells to be visible
(but greyed out) when another cell has a certain value.

for example this code would be in E5 -- =If(D5=15,2,"grey out E5")

IE if D5=15 then the value in E5 would be 2, otherwise E5 would be greyed
out and unaccesable.

Is this even possible? thanks in advance.
Athens