Can I Disable background error checking markers in the file?

[pbassett]

I wish to save space in my spreadsheet, which has sheet A containing extensive use of formulas and IF statements based on a Master sheet. This document will be distributed so I want people to see only the Values in the cells, not crazy formulae - I will discard Master and Sheet A and send only the resultant Values and some graphs.

The problem is there are tons of Background error checking green triangles in my Values only sheet. I can of course disable background error checking, but I want the entire spreadsheet to have this disabled when others open it.

Is this possible as a default for the document itself? Does anynore recommend another workaround? I use pivot tables to make charts and the file is 1.2MB which is not too big, but I really want to get rid of the green triangles.

 

[DRJ]

Tools | Options | Error Checking

[] Enable Background Error Checking

Uncheck

 

[Travis]

Re: Can I Disable background error checking markers in the f

Tools | Options | Error Checking

[] Enable Background Error Checking

Uncheck

Well thats no fun!!!

Sub Macro1()
    Application.ErrorCheckingOptions.BackgroundChecking = False
End Sub

 

[pbassett]

Re: Can I Disable background error checking markers in the f

Can I have that Macro run on Open? I would like the background error checking to be disabled whenever someone opens the file.

Pete

 

[Travis]

Re: Can I Disable background error checking markers in the f

sure

Sub Auto_Open()
    Application.ErrorCheckingOptions.BackgroundChecking = False 
End Sub

Just be aware your changing someones global settings and they may not like that.

 

[pbassett]

Re: Can I Disable background error checking markers in the f

Thank you !!!!

That solved it!

Pete