Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007: Formula bar text flicker, can't access other openworkbooks or close Excel.
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007: unusual flicker with Application.ScreenUpdating = True | Excel Programming | |||
Close Excel tables from Access | Excel Discussion (Misc queries) | |||
How to close Access from Excel VBA | Excel Programming | |||
Close Excel from Access | Excel Programming | |||
In Excel, how can i make text in a sigle sell flash, or flicker? | Excel Discussion (Misc queries) |