Vba - conditional formating

[nir020]

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

 

[Bob Phillips]

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


enabling should be obvious

--
---
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)

 

[Chip Pearson]

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.

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