You can only get that using an event macro that can be bypassed if the user
does not enable macros when the workbook is opened
http://www.cpearson.com/excel/case.htm
look for "Changing Case On Data Entry"
--
Regards,
Peo Sjoblom
Northwest Excel Solutions
www.nwexcelsolutions.com
(remove ^^ from email address)
Portland, Oregon
"tagr" wrote in message
...
Best I can tell this only changes a cells characters to Upper case after
the text is entered. So if a lower case 'z' is entered you must go back
to that cell and do ctrl u to make it upper case.
I am looking for something that will force Upper case on the fly.
Thanks for your help -
Jered
Lubbock, TX
--
tagr
------------------------------------------------------------------------
tagr's Profile:
http://www.excelforum.com/member.php...o&userid=32583
View this thread: http://www.excelforum.com/showthread...hreadid=523840