Upper Case not including specific Sheet

[RJ1969]

I tried to exclude the entire Sheet5 to not auto upper case.

Under "If Intersect(Target, Range("Sheet5")) Is Nothing Then" I typed the Sheet5 but it did not work. It's still doing the auto upper case.

Please Login or Register  to view this content.

Thanks.

[Norie]

Check Sh, not Target.

Please Login or Register  to view this content.

[AB33]

The syntax is wrong, but the reason for not getting the error is due to this line
On Error Resume Next
What this line saying is keep jumping into next line if that line errors.
SO, not good idea coding to put this line at the top.

[RJ1969]

Not working.
I just want the Sheet5 to excluded from the code.

[RJ1969]

Hi
Ok.. I kinda figure it out but what I need now is to exlude Sheet1 cell A1 and C1 not to have upper case.

I tried to add this code in it.

"If Intersect(Target, Sheet1.Range("A1,C1"))"

[Norie]

If all you wanted to do is exclude Sheet5 from the code all you would need is this as the first line of code.

Please Login or Register  to view this content.