MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Caps


Posted by Robb on February 05, 2002 6:46 PM

How do I limit the user to type CAPS (no lower case) in my workhseets?


Posted by Jaime on February 05, 2002 8:37 PM

Use data validation.

Select the entire sheet by cliking on the left hand corner . Then goto Data|Validation.
IN validation criteria set Allow to custom and
in the formula put this
=EXACT(A1,UPPER(A1))

Press Ok and you set.
Email me if any questions