Excel 2003 / Windows XP Pulsating Excel screen !!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I suppress jiggling / pulsating Excel screen, mouse pointer, task bar
Ready, etc. ??
 
Maybe it's a hardware problem--monitor/connections/video card???

Or a video driver problem. (get a fresh driver from the manufacturer).

I remember someone at work having a fan too close to the monitor. The motor
caused interference on the monitor. Moving the fan further away corrected the
problem.

(Any mechanical device plugged into the same outlet as that monitor???)

(Just guesses.)
 
Dave;
Nothing is connected to the computer, except the monitor and the printer.
No mechanical devices nearby.
I'm new to this MS Office Online Discussion Group Forum, and I'm not sure
how much details I'm allowed to provide.
Please advise. Thanks.
 
You're allowed to provide as much or as little detail as you see fit.

But to be honest, I've never seen any posts complaining about this. You may not
get much help, but it can't hurt to post.

(Most regulars don't like to see HTML posts or attachments to emails or
multiposting (same post sent multiple times to different newsgroups).)

But other than that, it's pretty much open season on everything excel related.

(And for privacy's sake, don't post anything that you wouldn't want seen on your
local supermarket's bulletin board.)
 
Dave;
For more details, please see my reply (2/3/2005 7:39 PM PST) to Frank Kabel
under: "How Can I make a cell flash in Excel". I've also replied somewhere
else, yet I couldn't locate my other reply or even the relevant post I
replied to ! (Is this what the contributers refer to as Cross-post and USENET
designation ??)
As I indicated earlier, I'm a new user of this forum, and I'm learning how
to navigate the site! I apologize for any protocol violations, if any!
Would appreciate any suggestions you might have regarding Suppressing the
"jiggle" in Excel screen, and activating "Paste" and "Paste Special" commands
while the OnTime method is on.
Thank you.
 
You may want to post a more specific question about the paste/paste special when
OnTime is on. Is it that the clipboard seems to be emptied?

If yes, then lots of macros will kill the clipboard. I don't know away around
it.

And second: if you're going to hang around any of the MS newsgroups, you may
want to dump the web interface and connect directly to the newsgroups (using
Outlook Express???).

Saved from a previous post:

If you have Outlook Express installed, try clicking on these links (or copy and
paste into MSIE).

news://msnews.microsoft.com/microsoft.public.excel.setup
news://msnews.microsoft.com/microsoft.public.excel.misc
news://msnews.microsoft.com/microsoft.public.excel.worksheet.functions
news://msnews.microsoft.com/microsoft.public.excel.newusers
news://msnews.microsoft.com/microsoft.public.excel.programming

(and a few more for MSWord)
news://msnews.microsoft.com/microsoft.public.word.docmanagement
news://msnews.microsoft.com/microsoft.public.word.word97vba
news://msnews.microsoft.com/microsoft.public.word.newusers
news://msnews.microsoft.com/microsoft.public.word.pagelayout
news://msnews.microsoft.com/microsoft.public.word.vba.addins
news://msnews.microsoft.com/microsoft.public.word.vba.beginners
news://msnews.microsoft.com/microsoft.public.word.vba.customization
news://msnews.microsoft.com/microsoft.public.word.vba.general
news://msnews.microsoft.com/microsoft.public.word.vba.userforms
news://msnews.microsoft.com/microsoft.public.word.word6-7macros

(You can always connect to more later)

Here are some links that explain it better:

Chip Pearson has some notes written by Leonard Meads at:
http://www.cpearson.com/excel/DirectConnect.htm

David McRitchie's notes at:
http://www.mvps.org/dmcritchie/excel/xlnews.htm
http://www.mvps.org/dmcritchie/excel/oe6.htm
http://www.mvps.org/dmcritchie/excel/oe6nws01.htm

Tushar Mehta's notes at:
http://www.tushar-mehta.com/misc_tutorials/oe_ng/index.htm

And if you're looking for old posts:

Or you can use google (maybe a few hours behind) to search for stuff you've
posted (and find the replies, too)

http://groups.google.com/advanced_group_search
http://groups.google.com/advanced_group_search?q=group:*Excel*&num=100

Ron de Bruin has an excel addin that you may like:
http://www.rondebruin.nl/Google.htm
Dave;
For more details, please see my reply (2/3/2005 7:39 PM PST) to Frank Kabel
under: "How Can I make a cell flash in Excel". I've also replied somewhere
else, yet I couldn't locate my other reply or even the relevant post I
replied to ! (Is this what the contributers refer to as Cross-post and USENET
designation ??)
As I indicated earlier, I'm a new user of this forum, and I'm learning how
to navigate the site! I apologize for any protocol violations, if any!
Would appreciate any suggestions you might have regarding Suppressing the
"jiggle" in Excel screen, and activating "Paste" and "Paste Special" commands
while the OnTime method is on.
Thank you.
Click to expand...
 
Hi Dave;
Thank you for your very informative reply.

1. The "Paste" and "Paste Special" commands in Excel::Edit menu list become
disabled while the OnTime method macro is running. Stop the macro, and the
commands become immediately available on the menu list! It seems to me that
I need to insert a statement of some sort in the macro code to cure this side
effect

2. Will certainly explore the many links you provided, particularly those
related to Excel. I'm familiar with probably a handful of them. It is
amazing how much stuff is available nowadays !!

Thanks again.
 
I just tried this simple example:

Option Explicit
Sub testme()
Application.OnTime Now + TimeSerial(0, 2, 0), "doitlater"
End Sub
Sub doitlater()
MsgBox "hi"
End Sub

This waits 2 minutes before running doitlater.

While excel was waiting for time to pass, I could copy and paste or paste
special as much as I wanted.

In fact, this "do-nothing" doitlater macro didn't even disturb the cutcopymode.

But most macros that do anything non-trivial will clear the clipboard.

If your Ontime macro does something important and you have it running a lot
(every few seconds???), then this could be why you lose the clipboard.

I don't know a workaround for this.


Hi Dave;
Thank you for your very informative reply.

1. The "Paste" and "Paste Special" commands in Excel::Edit menu list become
disabled while the OnTime method macro is running. Stop the macro, and the
commands become immediately available on the menu list! It seems to me that
I need to insert a statement of some sort in the macro code to cure this side
effect

2. Will certainly explore the many links you provided, particularly those
related to Excel. I'm familiar with probably a handful of them. It is
amazing how much stuff is available nowadays !!

Thanks again.
Click to expand...
 
Dave;

1. It is quite critical that the OnTime method works properly on this w/s.
If one or more of the algorithms fails, the OnTime would run at 1-sec
intervals and would continue until I fix the math. Otherwise, I would
mistakenly continue with the wrong results!

2. Once the math is fixed, then data is automatically copied from other
workbooks and pasted to this worksheet to try again while OnTime is running.

3. Your example is fine if I know in advance whether I need 2 sec, 2 min, 2
hr, or 2 days to fix the math, and the pasted new data leads to a successful
run. Then, and only then, the OnTime would stop.

4. So basically, my question is:
How to keep the Excel::Edit menu commands "Paste" and "Paste Special"
available while the OnTime is on ??
Greg Truby advised earlier to include IF Application.CutCopyMode=False in
the OnTime code to avoid this problem, and press ESC to continue after paste.
It did work, but it was in a different OnTime code.

Regards.
 
Again, I don't think it's the application.ontime that's killing the
..cutcopymode.

I bet it's what you do in that macro that you run.

You could stick a bunch of:

debug.print "step ##: " & application.cutcopymode

Throughout your code to see what individual line turns it off and then maybe you
could use a different technique that doesn't turn off .cutcopymode. (But just
running some macros will turn off the .cutcopymode.)

If you want to get out of the macro if the user has copied/cut something:

Near the top of your procedure (before you do anything that would change that
..cutcopymode flag):

If Application.CutCopyMode = False Then exit sub

But this means that the .ontime procedure isn't going to do what you initially
intended.


Dave;

1. It is quite critical that the OnTime method works properly on this w/s.
If one or more of the algorithms fails, the OnTime would run at 1-sec
intervals and would continue until I fix the math. Otherwise, I would
mistakenly continue with the wrong results!

2. Once the math is fixed, then data is automatically copied from other
workbooks and pasted to this worksheet to try again while OnTime is running.

3. Your example is fine if I know in advance whether I need 2 sec, 2 min, 2
hr, or 2 days to fix the math, and the pasted new data leads to a successful
run. Then, and only then, the OnTime would stop.

4. So basically, my question is:
How to keep the Excel::Edit menu commands "Paste" and "Paste Special"
available while the OnTime is on ??
Greg Truby advised earlier to include IF Application.CutCopyMode=False in
the OnTime code to avoid this problem, and press ESC to continue after paste.
It did work, but it was in a different OnTime code.

Regards.
Click to expand...
 
Back
Top