Locking a cell column to upercase
 

Is it possible to lock a column so that it only displays and prints in
uppercase?
--
Cyberwolf
Finder of Paths, Hunter of Prey
Ghost of the Night, Shadow of Day
The Wolf

Locking a cell column to upercase
 

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"

"Cyberwolf" wrote:

Is it possible to lock a column so that it only displays and prints in
uppercase?
--
Cyberwolf
Finder of Paths, Hunter of Prey
Ghost of the Night, Shadow of Day
The Wolf

Locking a cell column to upercase
 

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

"Cyberwolf" wrote:

Is it possible to lock a column so that it only displays and prints in
uppercase?
--
Cyberwolf
Finder of Paths, Hunter of Prey
Ghost of the Night, Shadow of Day
The Wolf

Locking a cell column to upercase
 

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

On Tue, 20 Feb 2007 12:04:25 -0800, Cyberwolf
wrote:

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