Need excel expert

[kashif.special2005]

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
I am Kashif, I have a cell A5 I have written a code that when user double click on A5 then a form should appear this is working fine, but I want that user could not write any thing in cell A5, I have applied cell protection but this is not working because after protect the cell user not able to double click on cell A5.<o></o>
<o> </o>
<o> </o>
Please help.<o></o>

 

[njimack]

Have you tried data validation? Custom: =A5=""

 

[kashif.special2005]

It is working..... Thanks.