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.?