Can I Disable background error checking markers in the file?

pbassett

Active Member
Joined
May 5, 2004
Messages
358
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.
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
Tools | Options | Error Checking

[] Enable Background Error Checking

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

DRJ said:
Tools | Options | Error Checking

[] Enable Background Error Checking

Uncheck
Well thats no fun!!!
Code:
Sub Macro1()
    Application.ErrorCheckingOptions.BackgroundChecking = False
End Sub
:laugh: :laugh: :laugh:
 
Upvote 0
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
 
Upvote 0
Re: Can I Disable background error checking markers in the f

sure
Code:
Sub Auto_Open()
    Application.ErrorCheckingOptions.BackgroundChecking = False 
End Sub
Just be aware your changing someones global settings and they may not like that.
 
Upvote 0

Forum statistics

Threads
1,224,591
Messages
6,179,768
Members
452,940
Latest member
rootytrip

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top