#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9
Default flashing worksheets

I have a couple of worksheets with buttons which, when pressed, will run
macros. Those buttons are grouped with imported figures and objects. When
scrolling the worksheet, it (the sheet) starts to flash incessantly. The
only way of getting it to stop flashing is to change the size of the window.
I don't know what's up here or how to fix this. No macros are running, I'm
just scrolling the worksheet. This is infuriating to say the least. Any
clues to fix this would be sincerely appreciated.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,365
Default flashing worksheets

A few questions to get things started:
What version of Excel (knowing the version of Windows may help also)?
What are the settings on these objects with regards to resizing/moving with
cells?
Define incessantly? Do you really mean it never stops flashing or that it
just goes on for a long time and finally settles down sometime after you
finish scrolling?

My initial guess is that the graphics engine is having to redraw these
objects over and over during the scroll process. If you want them to remain
in view, you might move them to the top of your worksheet and freeze the
window at a row below them. Perhaps make row 1 tall enough to contain them
and freeze the window just the one row.

"Felicity Shagwell" wrote:

I have a couple of worksheets with buttons which, when pressed, will run
macros. Those buttons are grouped with imported figures and objects. When
scrolling the worksheet, it (the sheet) starts to flash incessantly. The
only way of getting it to stop flashing is to change the size of the window.
I don't know what's up here or how to fix this. No macros are running, I'm
just scrolling the worksheet. This is infuriating to say the least. Any
clues to fix this would be sincerely appreciated.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9
Default flashing worksheets

Thank you for your suggestions. I have Excel 2003 and am running Windows XP
Pro sp2. Actually the problem appears to have self-resolved after closing
and reopening Excel. It was really weird. If it happens again, I'll repost
the query.
Definiition of incessantly: unceasingly, constantly, continuously,
never-ending, perpetually; eternally, everlasting; relentlessly,
unrelentingly, unremitting. :)

"JLatham" wrote:

A few questions to get things started:
What version of Excel (knowing the version of Windows may help also)?
What are the settings on these objects with regards to resizing/moving with
cells?
Define incessantly? Do you really mean it never stops flashing or that it
just goes on for a long time and finally settles down sometime after you
finish scrolling?

My initial guess is that the graphics engine is having to redraw these
objects over and over during the scroll process. If you want them to remain
in view, you might move them to the top of your worksheet and freeze the
window at a row below them. Perhaps make row 1 tall enough to contain them
and freeze the window just the one row.

"Felicity Shagwell" wrote:

I have a couple of worksheets with buttons which, when pressed, will run
macros. Those buttons are grouped with imported figures and objects. When
scrolling the worksheet, it (the sheet) starts to flash incessantly. The
only way of getting it to stop flashing is to change the size of the window.
I don't know what's up here or how to fix this. No macros are running, I'm
just scrolling the worksheet. This is infuriating to say the least. Any
clues to fix this would be sincerely appreciated.

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,365
Default flashing worksheets

I love it when someone uses the language accurately and succinctly!

Since nothing in Excel should be incessant other than accurate, predictable
results, that behavior is definitely unacceptable. Glad you've tamed the
beast for the moment. Sounds almost like a stuck key at this point.

"Felicity Shagwell" wrote:

Thank you for your suggestions. I have Excel 2003 and am running Windows XP
Pro sp2. Actually the problem appears to have self-resolved after closing
and reopening Excel. It was really weird. If it happens again, I'll repost
the query.
Definiition of incessantly: unceasingly, constantly, continuously,
never-ending, perpetually; eternally, everlasting; relentlessly,
unrelentingly, unremitting. :)

"JLatham" wrote:

A few questions to get things started:
What version of Excel (knowing the version of Windows may help also)?
What are the settings on these objects with regards to resizing/moving with
cells?
Define incessantly? Do you really mean it never stops flashing or that it
just goes on for a long time and finally settles down sometime after you
finish scrolling?

My initial guess is that the graphics engine is having to redraw these
objects over and over during the scroll process. If you want them to remain
in view, you might move them to the top of your worksheet and freeze the
window at a row below them. Perhaps make row 1 tall enough to contain them
and freeze the window just the one row.

"Felicity Shagwell" wrote:

I have a couple of worksheets with buttons which, when pressed, will run
macros. Those buttons are grouped with imported figures and objects. When
scrolling the worksheet, it (the sheet) starts to flash incessantly. The
only way of getting it to stop flashing is to change the size of the window.
I don't know what's up here or how to fix this. No macros are running, I'm
just scrolling the worksheet. This is infuriating to say the least. Any
clues to fix this would be sincerely appreciated.

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
Flashing cell Lloyd Excel Worksheet Functions 1 November 20th 06 12:47 PM
Screen flashing why? Chet Excel Discussion (Misc queries) 1 May 16th 06 08:25 PM
Flashing Warning Val Excel Worksheet Functions 1 January 21st 06 07:06 PM
Cell flashing Skioregon Excel Discussion (Misc queries) 1 October 10th 05 09:33 PM
Flashing Text JohnHill Excel Worksheet Functions 1 August 2nd 05 04:19 AM


All times are GMT +1. The time now is 04:51 AM.

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

About Us

"It's about Microsoft Excel"