View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] meh2030@gmail.com is offline
external usenet poster
 
Posts: 135
Default "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