Disable Grey Out condition formatting in Ribbon

**edwardhdwang** · 09-28-2012, 09:42 AM

Could any body to provide a vba code to disable(grey out) condition formatting command in ribbon. Because I generated a template and do not want user to change the condition formatting.

I have tried below, but it did not work...
Application.CommandBars(1).Controls("Format").Controls("Conditional Formatting...").Enabled = False

**Andy Pope** · 09-28-2012, 09:52 AM

In xl2007 and newer you control the ribbon via xml.
http://www.rondebruin.nl/ribbon.htm

Please Login or Register  to view this content.

**JosephP** · 09-28-2012, 09:54 AM

hi-please see forum rule 8

8. Don't cross-post without a link. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post. Expect cross-posts without a link to be closed.

please add links here to your cross-posts in any other forums. thanks :-)