Is there a way to have excel do this automatically. I have asap utilities but
you still have to initiate it each time.

If you put the code from this page in your personal macro workbook:
http://www.mvps.org/dmcritchie/excel/proper.htm

And then from this page:
http://www.mvps.org/dmcritchie/excel...#proper_change
put a variation of the Event Procedure under the heading "Invoking a Change
Event macro to change to Proper Case (#proper_change)" in the code for the
worksheet in question.

Then yes, you can.

Note: To test this, I removed:
If Target.Column < 4 Then Exit Sub 'only allow changes to Col D
from the Event code, and it worked for me.

In order to pull this off, you'll need to know a little about Event
Procedures and Personal.xls.
To get the basics, http://www.mvps.org/dmcritchie/excel/getstarted.htm.

Three cheers for David McRitchie's informative site.
--
tj


"terrya64" wrote:

Is there a way to have excel do this automatically. I have asap utilities but
you still have to initiate it each time.