Specific worksheet upper case

Hello,
I have this code: see below.

this part here: If Intersect(Target, Range("F:F")) Is Nothing Then
I want to specify for Sheet3
How do I redo the code that Sheet3 F:F is no upper auto.

Thanks.

Please Login or Register  to view this content.

What I meant except Column F:F Sheet3

.
.
Paste this in the Sheet Level Module :

Please Login or Register  to view this content.

Hi
I already had the code placed in thisworkbook. It works will all the worksheet.
Don’t have I specify the sheet that i want to exclude? I dont want an auto upper case on my worksheet Sheett3 in entire column F.

Tha ks

How about

Please Login or Register  to view this content.

Logit

Can this be work in workbook instead worksheet?

Please Login or Register  to view this content.

Hi guys,
I think I got it. But when I put "F:F" it does not work.

See this code:

Please Login or Register  to view this content.

I tried this too but no luck.

Please Login or Register  to view this content.

Do you want it to exclude sheet3 completely?
If so just add the line I showed in post#5

I don't want to exclude Sheet3. I just want to exclude Column F in Sheet3 but the rest will be an auto upper case I had the F:F Sheet3.

This code might work but if I work it with a specific cell then it work. Let say $F$1 it works fine.

Please Login or Register  to view this content.

.
It sounds like you want auto-capitalize for all Sheets, all columns, EXCEPT for SHEET 3, Column F.

Is that correct ?

Hi

Yes, you got it. : o)

Something like this:

Please Login or Register  to view this content.

but like I said when I typed F:F on the code it does not work. But if I use $F$1 for cell itself works.

.
If the macro he submitted works .. why are you changing it to : $F$1 ???

No, I was actually trying to change to F:F.

Maybe my code was wrong.

Like you said Logit
"It sounds like you want auto-capitalize for all Sheets, all columns, EXCEPT for SHEET 3, Column F."
This is correct. This is what I want to happen but the codes does not work at all.

Thanks.

.
I believe this works ...

Please Login or Register  to view this content.

Yay! Perfect!

Thank you Logit and thank you too Fluff13

.
You are welcome.