Changing case to English Style in a Macro

I'm using this simple code:

Please Login or Register  to view this content.

Where C3 is a name, eg: J SHAW

All I want to do in the code is to change the name from upper-case to English style case, ie: J Shaw, then for it to rename the tab.