This happens to me, intermittently, and when I restart Excel, everything works just fine. I realize if one is editing a cell, or focused on an object in Excel, then responsiveness from the VBE Editor is NILL for obvious reasons. However, I've checked and can select cells, use menus, etc., but when I switch windows to the VBE Editor, and try to type, or click something, all I get is a "bing" sound from the computer. No response.
Any ideas how to "clear" the problem without punting?