green triangles

[methody]

Hello I have a workbook with lots of green triangles in cells. I don't really know why they are there. there is a range of different types of formulas in them. I want to get rid of them. however, I know how to get rid of them in my workbook but I want to get rid of them for other people to whom i might send the workbooks

can you help please

 

[S.H.A.D.O.]

Hi methody,

If I understand you correctly these could occur because of several reasons.
I think it is to do with error checkingl like values stored as date etc.
If you click the Microsoft Office Button, then Excel Options and then click the Formulas and look at the Errror Checking options.
This will aplly to your SpreadSheet but it the recipient has theirs set to something different the error could or could not affect them.
What happens if you click the green triangle?

I hope this helps!

 

[zyzzyva57]

I found this helpful
Note, you have to select 19xx or for the conversion to be 20xx numerical

 

[Snakehips]

methody,

Two ways you might achieve what you want.....

1. The green triangles will not be visible if you protect the worksheet.
So you can either, selectively, format cells as locked/unlocked or if you do not require any cells to be locked then format the whole sheet as unlocked BUT then protect the sheet!!!

2. You could use vba to disable formula error checking when the file opens and then enable it when the file closes.

In the ThisWorkbook module......

Private Sub Workbook_Open ()
Application.ErrorCheckingOptions.BackgroundChecking = False
End Sub

Private Sub Workbook_BeforeClose (Cancel As Boolean)
Application.ErrorCheckingOptions.BackgroundChecking = True
End Sub

Hope that helps.

 

[methody]

thanks very much