View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
spreadsheetlady spreadsheetlady is offline
external usenet poster
 
Posts: 11
Default Getting rid of the green triangles in XL 2010

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