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

application.CommandBars(1).Controls("Format").Cont rols("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)



"nir020" wrote in message
...
Is it possible to write some code to disable condtional formatting and
then
later to on re-enable conditional formatting.?

application.CommandBars(1).Controls("Format").Cont rols("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)

"Bob Phillips" wrote in message
...
application.CommandBars(1).Controls("Format").Cont rols("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)



"nir020" wrote in message
...
Is it possible to write some code to disable condtional formatting and
then
later to on re-enable conditional formatting.?