Turn off AutoCorrect in Excel via VBA?

  • Thread starter Thread starter TomK via OfficeKB.com
  • Start date Start date
T

TomK via OfficeKB.com

Can I turn off the AutoCorrect Options in Excel via VBA script?

Thanks,
Tom
 
sub turnoffacorr()
With Application.AutoCorrect
.TwoInitialCapitals = False
.CorrectSentenceCap = False
.CapitalizeNamesOfDays = False
.CorrectCapsLock = False
.ReplaceText = False
.DisplayAutoCorrectOptions = False
End With
Application.AutoCorrect.AutoExpandListRange = False


End sub
 

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

Get AutoCorrect Options with VBA 5
Excel VBA in Citrix. 0
Turning off Whole Word selection in Excel 2007 1
AutoComplete error in (my?) Excel 2
Turning off display while VBA running 3
Unable to set the Display Alerts property of the application class 6
Turning on/off the Hourglass pointer in Excel 1
turn off autocorrect in excel 2007 1

Back
Top