Excel 2007: Formula bar text flicker, can't access other openworkbooks or close Excel.

D

dbKemp

I am working on a fairly large application that refers to code in
several addins. Userforms are used, but there are no shapes, charts,
etc. on any worksheet.

My problem is that 'randomly', but usually some time after using the
main form (that can interact with cells on a worksheet) the test in
the formula bar textbox starts flickering like some code is caught in
an endless loop. I can interact with Excel at this point, but can't
naviagate to other workbooks or even close Excel without ending it's
process via TaskManager. The only way to get the flickering to stop is
to close Excel.

I have googled and searched this forum, but have found no expanation
or solution. I did see one promising thread that showed similar
symptoms when a worksheet cell was selected and then a shape was
selected. There was a snippet of code in that thread that caused the
text to flicker, but it would stop.

When this happens Excel consumes all of one of the dual core
processors on my computer. (50% total)
Also there is usually remnants of the user form in the dropdown box of
the formula bar.

Can any one help? I have O2007 SP2 installed.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top