Turn off AutoCorrect in Excel via VBA?

[TomK via OfficeKB.com]

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

Thanks,
Tom

[Michael]

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
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.

Post by TomK via OfficeKB.com
Can I turn off the AutoCorrect Options in Excel via VBA script?
Thanks,
Tom
--
Thanks,
Tom
Message posted via http://www.officekb.com

[TomK via OfficeKB.com]

Thanks, Michael! I just stumbled over the right keywords in my searching to
find something close to that, except for the "Application.AutoCorrect.
AutoExpandListRange = False" line. What does that do?

Thanks,
Tom