Focus, focus, who has the focus?

This might not be your problem. But, then, again, it might.


I find that a lot of things in Excel don't work when anything other than a cell has the focus.

So, when you have ActiveX controls, or chart, or other embedded objects, and one of them has focus, Excel acts ... well ... weird.

Try a liberal sprinkling of:
ActiveCell.Activate


I hope this helps.