Vba - conditional formating

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nir020 - 27 Nov 2007 16:54 GMT

Is it possible to write some code to disable condtional formatting and then
later to on re-enable conditional formatting.>?

Reply to this Message

Bob Phillips - 27 Nov 2007 18:05 GMT

application.CommandBars(1).Controls("Format").Controls("Conditional
Formatting...").enabled=false

enabling should be obvious

Signature

---
HTH

Bob

__________________________________________
UK Cambridge XL Users Conference 29-30 Nov
http://www.exceluserconference.com/UKEUC.html

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> Is it possible to write some code to disable condtional formatting and
> then
> later to on re-enable conditional formatting.>?

Reply to this Message

Chip Pearson - 28 Nov 2007 00:25 GMT

> application.CommandBars(1).Controls("Format").Controls("Conditional
> Formatting...").enabled=false

As I understood the question, the user wanted to disable/enable the *action*
of CF, not disable/enable the creation of CF formats. I do not believe it is
possible to prevent a CF format from being applied if the condition is met.
There is nothing analogous to EnableEvents for CF.

Signature

Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)

> application.CommandBars(1).Controls("Format").Controls("Conditional
> Formatting...").enabled=false
[quoted text clipped - 4 lines]
>> then
>> later to on re-enable conditional formatting.>?

Reply to this Message