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

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

Hi,

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

TIA
 
Hi,

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

TIA
Click to expand...

Bob,

Application.ErrorCheckingOptions.BackgroundChecking = False

Best,

Matthew Herbert
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2003 vs Excel 2007 #N/A in VB 4
Excel 2003 VB referencing #N/A not working but works in Excel 2007 1
Just switched to Excel 2007 from 2003 - Unclear how to enable macros 2
Change background on excel chart 1
Workbook_Open not executing in Excel 2007 2
compatibility checker in excel 2007, turning it off 2
Code in Excel 2000 template doesn't work in Excel 2010 1
Simple VBA Code Working in Excel 2007 but not Excel 2003 #N/A 1

Back
Top