Workbook.CaseSensitive (Excel)

True if the workbook distinguishes between uppercase and lowercase when comparing content.

Dim booCaseSensitive As Boolean
booCaseSensitive = ActiveWorkbook.CaseSensitive