Locking a cell column to upercase

C

Cyberwolf

Is it possible to lock a column so that it only displays and prints in
uppercase?
 
B

BROCK8292

i dont know about locking the cells but an easy way to display only caps
would be to change the font of the column to one that only displays capital
letters
try "HANA"
 
C

Chad

Try using =upper() function. This allows you to reference a cell and make it
in all uppercase. Otherwise, you can use VBA to change a specific cell to
uppercase, but you'll have to run a macro or use the on selection change
within the worksheet to change it. Hope this helps!

-Chad
 
G

Gord Dibben

One way is to use event code on that column.

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Not Application.Intersect(Range("A:A"), Target) Is Nothing Then
On Error GoTo ErrHandler
Application.EnableEvents = False
Target.Formula = UCase(Target.Formula)
End If
ErrHandler:
Application.EnableEvents = True
End Sub

This is event code. Right-click on the sheet tab and "View Code"

Copy/paste the code into that sheet module.

As you enter text in column A it will change to upper case.


Gord Dibben MS Excel MVP
 
Top