Prev: Identify when Excel is displaying ### in a cell? (contents>width)
Next: growing excel database
From: spreadsheetlady on 12 May 2010 21:16
Hi,
I wrote a spreadsheet program that was written in XL 2007.
Our company has now upgraded to XL 2010.
Many cells have Conditional Formatting and do not appear until certain
values are entered. This keeps the spreadsheet clean and simple.
Excel 2010 has a feature that displays a little green triangle in the top
left hand corner. This is visual even with the Conditional Formatting on. I
just started using 2010 today, but I believe it shows formula errors such as
" Value!".
The whole company is asking me about the green dots all over the spreadsheet
program now. It looks weird.
Is there a way in Visual Basic to turn these off, say when the spreadsheet
is first loading or activated?
Hope I explained this that you can understand.
We have Windows 7 64 bit with Excel 2010.
Thanks in advance,
Amy
From: Ed Ferrero on 12 May 2010 22:14
Hi Amy,

File -> Options -> Formulas
Look at the Error Checking Rules, and turn off as many as you want.

Or, change the error color indicator to white. That will still alert you to
an error when the cell is selected, but you wont be able to see the
triangles (as long as you have white cell background).

Ed Ferrero
www.edferrero.com

From: spreadsheetlady on 14 May 2010 18:15
Thanks Ed. I found the Error Checking.
I entered this in the Open Event of the Workbook.

It works on my workbook, but....

Does anyone know how to write a code line to toggle this in the Open Event
in the Workbook? I'm new to VB.

I've never written a logic "IF" procedure in VB. But I was thinking of
something like:
'IF Formula BackgroundChecking = TRUE
THEN make Formula BackgroundChecking = FALSE

Something like that would be better don't you think? In case someone
already has it set to FALSE or Off.

Thanks again,
Amy



"Ed Ferrero" wrote:

> Hi Amy,
>
> File -> Options -> Formulas
> Look at the Error Checking Rules, and turn off as many as you want.
>
> Or, change the error color indicator to white. That will still alert you to
> an error when the cell is selected, but you wont be able to see the
> triangles (as long as you have white cell background).
>
> Ed Ferrero
> www.edferrero.com
>
> .
>
From: Gord Dibben on 14 May 2010 18:23
If Application.ErrorCheckingOptions.BackgroundChecking = True Then
Application.ErrorCheckingOptions.BackgroundChecking = False

Stick into Thisworkbook Module in Workbook_Open event.

If you had used the macro recorder while toggling on/off you would have
found the necessary syntax.


Gord Dibben MS Excel MVP


On Fri, 14 May 2010 15:15:01 -0700, spreadsheetlady
<spreadsheetlady(a)discussions.microsoft.com> wrote:

>Thanks Ed. I found the Error Checking.
>I entered this in the Open Event of the Workbook.
>
>It works on my workbook, but....
>
>Does anyone know how to write a code line to toggle this in the Open Event
>in the Workbook? I'm new to VB.
>
>I've never written a logic "IF" procedure in VB. But I was thinking of
>something like:
>'IF Formula BackgroundChecking = TRUE
>THEN make Formula BackgroundChecking = FALSE
>
>Something like that would be better don't you think? In case someone
>already has it set to FALSE or Off.
>
>Thanks again,
>Amy
>
>
>
>"Ed Ferrero" wrote:
>
>> Hi Amy,
>>
>> File -> Options -> Formulas
>> Look at the Error Checking Rules, and turn off as many as you want.
>>
>> Or, change the error color indicator to white. That will still alert you to
>> an error when the cell is selected, but you wont be able to see the
>> triangles (as long as you have white cell background).
>>
>> Ed Ferrero
>> www.edferrero.com
>>
>> .
>>

 | 
Pages: 1
Prev: Identify when Excel is displaying ### in a cell? (contents>width)
Next: growing excel database