T TomK via OfficeKB.com Oct 10, 2007 #1 Can I turn off the AutoCorrect Options in Excel via VBA script? Thanks, Tom
G Guest Oct 10, 2007 #2 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
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
T TomK via OfficeKB.com Oct 10, 2007 #3 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.aspx/excel-programming/200710/1
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.aspx/excel-programming/200710/1
