Hi guys

I've been writing a system in Excel which uses multiple VBA codings and ActiveX Controls. The ActiveX Controls are Drop-downs, Checkboxes and Spin Buttons primarily and all trigger routines when activated. The sheets are Protected and the routines unlock and then lock them when finished etc.

My problem is that at certain times, cells which are unlocked become uneditable. You can click on them, highlight them with a cursor, right-click to access the delete contents function etc - but you cannot enter anything from the keyboard into the cell.

The problem disappears when I activate another sheet in the same workbook and then immediately come back into the original sheet. Then I can type away merrily into the cells that were previously inaccessible.

There appears to be no pattern to establish what is causing the issue. There's no spinning cursor or anything else to indicate what it could be. I should add that all other cells which use ActiveX Controls to input data will continue to function normally when the problem occurs.

I should add that I'm totally self-taught with VBA so pardon me if it's something really obvious! I'd just appreciate if some of you experts could give me a steer as to where to look if the symptoms sound obvious to you.

Thanks very much all in advance.

Yours in anticipation

Shaun