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