Simple or Not?

[August]

Can a cell be formatted so that whaterver text is typed in it is in Capitals, ideally this would be in a protected worksheet

Thanks

 

[August]

That works great

Just out of curiosity........why couldn't the other code be changed to work on a range.....(keep it simple if poss)


Thanks for all your help

 

[fairwinds]

One cell is not equal to a range so I need to use intersect to see if they do.

I need to use WorksheetFunction as Proper is not a VBA command.

I need to "EnableEvents = False" else code will execute again and again.

 

[August]

Many thanks
It really is true, for me anyway "the more you find out...the less you know"