As a side note, I am having the same problem with a number of other new workbooks, but are having no trouble at all with code written in Office 2003, and saved as xlsm.
This post contains VBA macro example on how to convert the words, phrase or sentence from 'lower' to ' UPPER'(Capital letters) ' Proper' or ' Sentence' case or vice-versa using Microsoft Visual Basic for Applications in Microsoft Excel.
We will loop through all cells using FOR-NEXT and will set the case as required.
I have an Excel project distributed to several hundred users that is self updating.
When launched, it compares it's version number to a current version number on a remote server.
Slight difference, where the latter snippet allows you to work with tables with empty rows and/or columns.