How to turn off little green triangle in a cell

043792 · Sep 1st 2005

Is there any way in VBA to disable the little green triangles that showup to highlight soft errors like number formatted as text?

**Jack in the UK** · Sep 1st 2005

Re: to loose the 'green triange'

That is background checking can be switched on / off by Tools|Options - error checking tab / untick in the toip settings options, background checking

jiuk

043792 · Sep 1st 2005

Re: to loose the 'green triange'

perfect, thanks

**Jack in the UK** · Sep 1st 2005

Re: to loose the 'green triange'

043792
Junior Member - No worries buddy a pleasure thanks for lettin me know, very kind.

jiuk

Participate now!