Hi Everyone,

i'm new to this forum and i have a question for you reguardin
excel VBA. I want to declare in a module a function or sub that wil
change the CELL properties where the function has been called from i
another cell contains certain information...example:

A B C D
1 100 5.5 =ONOFFCell(A1)
2 0.5 2 =ONOFFCEll(A2)
3 .
4 .

the ONOFFCELL (sub or function) must DISABLE ITSELF (CELL C1) so tha
people cannot enter anything in C1 cell IF the cell A1 value let say i
bigger than "0". Then on each line i will have to repeat the sam
function etc. etc.

How can i do that? Can someone help me ?

Thank you!

William

--
will9
-----------------------------------------------------------------------
will99's Profile: http://www.excelforum.com/member.php...fo&userid=2679
View this thread: http://www.excelforum.com/showthread.php?threadid=40041