Gies,Brad <[EMAIL PROTECTED]> wrote on Thu, 10 Nov 2005 11:57:31 -0500:
> This one seems to work fairly well, but we're still getting the green > triangles on some columns and seemingly random cells. But it is much > better than what it was. Hi Brad, The green triangles can also be selectively turned off. This is the new Error Checking feature in Excel. Go to Tools> Options> Error Checking and you can either disable any individual check, or turn it all off completely. I think this setting is global for Excel, but if you wanted to turn it off temporarily you could do it through automation as well. Just record a macro of turning something off, and go into the VBA editor and snip out the necessary code to use in Delphi. I was annoyed by the triangles at first but now I find they're quite helpful. They show up in Access too. For an Excel project I worked on recently, I wrote a VBA routine that goes through every sheet and lists every cell reference that has an error flag on it. Made it easy to find all the div by 0s and miscopied formulas on over 100 worksheets. - Todd __________________________________________________ Delphi-Talk mailing list -> [email protected] http://www.elists.org/mailman/listinfo/delphi-talk
