Removing little green triangle

**yewkiang** · 02-13-2007, 03:48 AM

i have trouble removing these litttle green triangles at the top left hand of each cell.

i can do it for one cell. but does anyone knows how to do it for a big array of cells?

cheers

**Bryan Hessey** · 02-13-2007, 04:17 AM

Originally Posted by yewkiang

i have trouble removing these litttle green triangles at the top left hand of each cell.

i can do it for one cell. but does anyone knows how to do it for a big array of cells?

cheers

Hi,

a quote of "Following this procedure will make the error message wording invisible, assuming of course, that you haven't changed the default background color of your worksheet. It still leaves the little green triangle in the cell's upper left corner. To get rid of that as well, go to the Tools menu and click Options; then click the Error Checking tab. Click the Enable Background Error Checking checkbox to clear it, and your triangles will disappear. "

from http://www.skillpath.com/ec/detail.html?a=281

might help you.

---

**VBA Noob** · 02-13-2007, 04:20 AM

Hi,

To turn off the warning goto

Tools > options > Error Checking > and untick which ones you wish to avoid

If you want to leave it switch on then select the rows then on the first cell click the error message and it should turn it off for all cells

VBA Noob