ExcelBanter - "Enable background error checking" on/off in Excel 2007 SP2

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - "Enable background error checking" on/off in Excel 2007 SP2 (https://www.excelbanter.com/excel-programming/427966-enable-background-error-checking-off-excel-2007-sp2.html)

Bob[_78_]

"Enable background error checking" on/off in Excel 2007 SP2

Hi,

Is there a way to turn on/off the "Enable background error checking" tick
box in Excel 2007 SP2 using code?

TIA

[email protected]

"Enable background error checking" on/off in Excel 2007 SP2

On May 4, 3:36*pm, "Bob" wrote:
Hi,

Is there a way to turn on/off the "Enable background error checking" tick
box in Excel 2007 SP2 using code?

TIA

Bob,

Application.ErrorCheckingOptions.BackgroundCheckin g = False

Best,

Matthew Herbert

All times are GMT +1. The time now is 12:26 AM.