Disable extend data range for workbook

[Figboot]

I have a workbook which has some conditional formatting in columns A:B. A user will be putting notes in column C. When they put notes, the conditional formatting automatically extends to column C. I know that you can turn it off on an individual compter (Options/Advanced/uncheck "Extend data range formats and formulas"), but is there a way via VBA to turn it off on this specific workbook, so that when I share it with others it will work correctly for them?

I tried:

Application.AutoCorrect.AutoFillFormulasInLists = False

But that didn't seem to work. Any suggestions?

[kev_]

Try

Please Login or Register  to view this content.

[kev_]

or a heavy handed workaround which prevents CF from being applied to column C

In sheet module:

Please Login or Register  to view this content.

[Figboot]

Thanks. This code didn't prevent the CF from expanding...I'll play around with your second suggestion. Appreciate the assistance

[kev_]

Automatically extending data range formats and formulas is a bit of a curate's egg
- Expanding down a column is usually ok
- Expanding into the next column is usually not ok (data type generally varies by column

Application-level default settings are very useful but, wherever it makes sense, the user should also have access to workbook-level settings
- Microsoft should add a parallel set of options set out to look EXACTLY the same (with some options greyed out because not available)

[Figboot]

I came up with a simple solution that didn't involve any code. I just put DIFFERENT conditional formatting in column C that really didn't affect the text in any way. That way, the CF in A:B won't auto extend. Now...why didn't I think of that sooner? :-)

[kev_]

The simplest solution is often the best