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

Thanks,
Tom

--
Thanks,
Tom

Message posted via http://www.officekb.com

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.




"TomK via OfficeKB.com" wrote:

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

Thanks,
Tom

--
Thanks,
Tom

Message posted via http://www.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

--
Thanks,
Tom

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200710/1