I often have to display results from an excel file in powerpoint or on paper,
so I've adjusted the "Error Checking" tab under "Options" to remove the error
indicators for the most common errors ("Inconsistent Formula...", "Formula
Omits Cells...").

If I send the file to other people who haven't modified their "Error
Checking" tabs, those error indicators will show up again.

Is there anyway to hide those error indicators permanently, no matter who
opens up the file?

Thanks.

Turn off EC when workbook opens............

Private Sub Workbook_Open()
Application.ErrorCheckingOptions.BackgroundCheckin g = False
End Sub

Turn back on if user switches workbooks.......................

Private Sub Workbook_Deactivate()
Application.ErrorCheckingOptions.BackgroundCheckin g = True
End Sub

Turn back off if user switches back to yours...............................

Private Sub Workbook_Activate()
Application.ErrorCheckingOptions.BackgroundCheckin g = False
End Sub

Turn back on when user closes yours........................

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

All to be copied to Thisworkbook module.


Gord Dibben MS Excel MVP



On Thu, 10 Apr 2008 15:19:01 -0700, MrBlades
wrote:

I often have to display results from an excel file in powerpoint or on paper,
so I've adjusted the "Error Checking" tab under "Options" to remove the error
indicators for the most common errors ("Inconsistent Formula...", "Formula
Omits Cells...").

If I send the file to other people who haven't modified their "Error
Checking" tabs, those error indicators will show up again.

Is there anyway to hide those error indicators permanently, no matter who
opens up the file?

Thanks.