How to delete Straight line connector pointing to a field automatically

[ldsone]

Hi,

I have a question: Is it possible to construct an IF statement in excel that it would delete an existing arrow connector pointing to a cell if a condition in the cell is false.

I have a function

Please Login or Register  to view this content.

can I change it anyway to accomplish that. Instead of putting N/A, I would like to delete the arrow connector.

Thanks.

[ldsone]

Cross-posted : http://www.ozgrid.com/forum/showthre...546#post674546

[ldsone]

I have this code that allows me to delete shapes in range:

Please Login or Register  to view this content.

Only thing left is figure out how to use it to my advantage.

[ldsone]

ok I have managed to achieve one thing, The arrow connector is being deleted, but it only works for the first if statement, the second if ststement is not responsive, where am I going wrong?

Please Login or Register  to view this content.