I have a fairly basic sheet with 5 columns and 3000+ rows and a few Active X controls 2 listboxes, 1 combo box and a spin button. The first column has formula to construct consecutive dates by adding 1 to previous row date. All rest is text.

I have some very simple conditional formatting - just two rules. 1 to highlight Monday rows and 1 to pick out a few special text entries.
All works as it should.

Problem is I cannot edit any of the controls. Design mode seems to be switched off. If I remove the conditional format rules - no problem.

Anyone else had similar problem? Using Excel 2010.

Any solutions work arounds? I have tried disabling the rules using a flag cell and the stop if true option. This doesn't seem to work for some reason.

John B