CorrectCapsLock Property [Excel 2003 VBA Language Reference]
True if Microsoft Excel automatically corrects accidental use of the CAPS LOCK key. Read/write Boolean.
Example
This example enables Microsoft Excel to automatically correct accidental use of the CAPS LOCK key.
Application.AutoCorrect.CorrectCapsLock = True
Applies to | AutoCorrect Object