Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 58
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007: unusual flicker with Application.ScreenUpdating = True Paul Martin[_2_] Excel Programming 2 January 17th 10 07:13 AM
Close Excel tables from Access StacyM Excel Discussion (Misc queries) 0 August 11th 09 09:04 PM
How to close Access from Excel VBA Steve P[_2_] Excel Programming 2 October 12th 07 10:37 PM
Close Excel from Access Guriuz Excel Programming 6 June 8th 07 07:53 AM
In Excel, how can i make text in a sigle sell flash, or flicker? Piersy Excel Discussion (Misc queries) 0 December 14th 06 04:00 AM


All times are GMT +1. The time now is 10:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"