All caps all the time? Possible?

[OpOrange]

Is there a way to make it that a whole column is always in caps no matter what? or is there a macro I would have to write?

[Richard Buttrey]

Hi,

You could use the =UPPER(A1) function in a helper column then copy that and paste it back to the original column as values.

[Arkadi]

If you want it to happen automatically, you need a macro, otherwise as Richard said, you can use a formula in a different column for conversion.
A very simple worksheet change macro should work great though.

[OpOrange]

Is there a way I could just make it happen automatically? Without running a macro? Otherwise I will have to ask for help in the macro section of the forum lol.

[protonLeah]

You can try "Bank Gothic" font.

[OpOrange]

I don't have that font. :/ I will consult the macro gods in there forum.

[Arkadi]

if you need a macro, then open VB editor (alt-f11)
double click the sheet name you want the macro to work in (menu on left)
and paste this in there: (this is not in a module, it is a worksheet change event)

Please Login or Register  to view this content.

[OpOrange]

Here is what I was hoping for, and what I posted in the macro forum.

I need a macro that makes all the text in column G capitalized. Except for one sheet. When I view it in VBA its sheet 5, the name of the sheet is "BLANK"

[Arkadi]

Yep I saw... my post above still applies I think, just need to put it on each sheet you want to auto-capitalize. I replied in macro help and changed the code to column G in that version.

[ben_hensel]

What about enabling cruise control for cool?

A little more seriously, it looks like the VBA approaches are not too intimidating.

[OpOrange]

This will work. I misunderstood. Sorry I failed.

[Arkadi]

Op, I put the workbook version in the macros thread, hope you found it?

[OpOrange]

This does not seem to be working for me all the time? Is there a macro that could be written to automatically do this from G10:G500 on all worksheets except the one in the first postion? Its name is "BLANK".

[OpOrange]

Is anyone able to help?

[protonLeah]

Free bank gothic fonts: here (lt, med & bold)

[OpOrange]

will my macro pick that up as being a capital even if its not typed that way?

[newdoverman]

You could try this registry edit that should enable the caps key as default. Of course, in other applications, you would have to hit the caps key to turn it off.

http://www.razumny.no/2009/12/set-de...olllock-state/