Excel 2003 / Windows XP Pulsating Excel screen !!

[monir]

How do I suppress jiggling / pulsating Excel screen, mouse pointer, task bar
Ready, etc. ??

[Dave Peterson]

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.)

monir wrote:
>
> How do I suppress jiggling / pulsating Excel screen, mouse pointer, task bar
> Ready, etc. ??

--

Dave Peterson

[monir]

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.

"Dave Peterson" wrote:

> 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.)
>
> monir wrote:
> >
> > How do I suppress jiggling / pulsating Excel screen, mouse pointer, task bar
> > Ready, etc. ??
>
> --
>
> Dave Peterson
>

[Dave Peterson]

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.)

monir wrote:
>
> 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.
>
> "Dave Peterson" wrote:
>
> > 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.)
> >
> > monir wrote:
> > >
> > > How do I suppress jiggling / pulsating Excel screen, mouse pointer, task bar
> > > Ready, etc. ??
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson

[monir]

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.

"Dave Peterson" wrote:

> 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.)
>
> monir wrote:
> >
> > 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.
> >
> > "Dave Peterson" wrote:
> >
> > > 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.)
> > >
> > > monir wrote:
> > > >
> > > > How do I suppress jiggling / pulsating Excel screen, mouse pointer, task bar
> > > > Ready, etc. ??
> > >
> > > --
> > >
> > > Dave Peterson
> > >
>
> --
>
> Dave Peterson
>

[Dave Peterson]

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/microsof...ic.excel.setup
news://msnews.microsoft.com/microsoft.public.excel.misc
news://msnews.microsoft.com/microsof...heet.functions
news://msnews.microsoft.com/microsof...excel.newusers
news://msnews.microsoft.com/microsof...el.programming

(and a few more for MSWord)
news://msnews.microsoft.com/microsof....docmanagement
news://msnews.microsoft.com/microsof...word.word97vba
news://msnews.microsoft.com/microsof....word.newusers
news://msnews.microsoft.com/microsof...ord.pagelayout
news://msnews.microsoft.com/microsof...ord.vba.addins
news://msnews.microsoft.com/microsof....vba.beginners
news://msnews.microsoft.com/microsof....customization
news://msnews.microsoft.com/microsof...rd.vba.general
news://msnews.microsoft.com/microsof....vba.userforms
news://msnews.microsoft.com/microsof....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_tut...e_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_gr...Excel*&num=100

Ron de Bruin has an excel addin that you may like:
http://www.rondebruin.nl/Google.htm

monir wrote:
>
> 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.
>
> "Dave Peterson" wrote:
>
> > 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.)
> >
> > monir wrote:
> > >
> > > 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.
> > >
> > > "Dave Peterson" wrote:
> > >
> > > > 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.)
> > > >
> > > > monir wrote:
> > > > >
> > > > > How do I suppress jiggling / pulsating Excel screen, mouse pointer, task bar
> > > > > Ready, etc. ??
> > > >
> > > > --
> > > >
> > > > Dave Peterson
> > > >
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson

[monir]

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.


"Dave Peterson" wrote:

> 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/microsof...ic.excel.setup
> news://msnews.microsoft.com/microsoft.public.excel.misc
> news://msnews.microsoft.com/microsof...heet.functions
> news://msnews.microsoft.com/microsof...excel.newusers
> news://msnews.microsoft.com/microsof...el.programming
>
> (and a few more for MSWord)
> news://msnews.microsoft.com/microsof....docmanagement
> news://msnews.microsoft.com/microsof...word.word97vba
> news://msnews.microsoft.com/microsof....word.newusers
> news://msnews.microsoft.com/microsof...ord.pagelayout
> news://msnews.microsoft.com/microsof...ord.vba.addins
> news://msnews.microsoft.com/microsof....vba.beginners
> news://msnews.microsoft.com/microsof....customization
> news://msnews.microsoft.com/microsof...rd.vba.general
> news://msnews.microsoft.com/microsof....vba.userforms
> news://msnews.microsoft.com/microsof....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_tut...e_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_gr...Excel*&num=100
>
> Ron de Bruin has an excel addin that you may like:
> http://www.rondebruin.nl/Google.htm
>
> monir wrote:
> >
> > 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.
> >
> > "Dave Peterson" wrote:
> >
> > > 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.)
> > >
> > > monir wrote:
> > > >
> > > > 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.
> > > >
> > > > "Dave Peterson" wrote:
> > > >
> > > > > 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.)
> > > > >
> > > > > monir wrote:
> > > > > >
> > > > > > How do I suppress jiggling / pulsating Excel screen, mouse pointer, task bar
> > > > > > Ready, etc. ??
> > > > >
> > > > > --
> > > > >
> > > > > Dave Peterson
> > > > >
> > >
> > > --
> > >
> > > Dave Peterson
> > >
>
> --
>
> Dave Peterson
>

[Dave Peterson]

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.



monir wrote:
>
> 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.
>
>
> "Dave Peterson" wrote:
>
> > 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/microsof...ic.excel.setup
> > news://msnews.microsoft.com/microsoft.public.excel.misc
> > news://msnews.microsoft.com/microsof...heet.functions
> > news://msnews.microsoft.com/microsof...excel.newusers
> > news://msnews.microsoft.com/microsof...el.programming
> >
> > (and a few more for MSWord)
> > news://msnews.microsoft.com/microsof....docmanagement
> > news://msnews.microsoft.com/microsof...word.word97vba
> > news://msnews.microsoft.com/microsof....word.newusers
> > news://msnews.microsoft.com/microsof...ord.pagelayout
> > news://msnews.microsoft.com/microsof...ord.vba.addins
> > news://msnews.microsoft.com/microsof....vba.beginners
> > news://msnews.microsoft.com/microsof....customization
> > news://msnews.microsoft.com/microsof...rd.vba.general
> > news://msnews.microsoft.com/microsof....vba.userforms
> > news://msnews.microsoft.com/microsof....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_tut...e_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_gr...Excel*&num=100
> >
> > Ron de Bruin has an excel addin that you may like:
> > http://www.rondebruin.nl/Google.htm
> >
> > monir wrote:
> > >
> > > 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.
> > >
> > > "Dave Peterson" wrote:
> > >
> > > > 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.)
> > > >
> > > > monir wrote:
> > > > >
> > > > > 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.
> > > > >
> > > > > "Dave Peterson" wrote:
> > > > >
> > > > > > 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.)
> > > > > >
> > > > > > monir wrote:
> > > > > > >
> > > > > > > How do I suppress jiggling / pulsating Excel screen, mouse pointer, task bar
> > > > > > > Ready, etc. ??
> > > > > >
> > > > > > --
> > > > > >
> > > > > > Dave Peterson
> > > > > >
> > > >
> > > > --
> > > >
> > > > Dave Peterson
> > > >
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson

[monir]

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.



"Dave Peterson" wrote:

> 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.
>
>
>
> monir wrote:
> >
> > 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.
> >
> >
> > "Dave Peterson" wrote:
> >
> > > 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/microsof...ic.excel.setup
> > > news://msnews.microsoft.com/microsoft.public.excel.misc
> > > news://msnews.microsoft.com/microsof...heet.functions
> > > news://msnews.microsoft.com/microsof...excel.newusers
> > > news://msnews.microsoft.com/microsof...el.programming
> > >
> > > (and a few more for MSWord)
> > > news://msnews.microsoft.com/microsof....docmanagement
> > > news://msnews.microsoft.com/microsof...word.word97vba
> > > news://msnews.microsoft.com/microsof....word.newusers
> > > news://msnews.microsoft.com/microsof...ord.pagelayout
> > > news://msnews.microsoft.com/microsof...ord.vba.addins
> > > news://msnews.microsoft.com/microsof....vba.beginners
> > > news://msnews.microsoft.com/microsof....customization
> > > news://msnews.microsoft.com/microsof...rd.vba.general
> > > news://msnews.microsoft.com/microsof....vba.userforms
> > > news://msnews.microsoft.com/microsof....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_tut...e_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_gr...Excel*&num=100
> > >
> > > Ron de Bruin has an excel addin that you may like:
> > > http://www.rondebruin.nl/Google.htm
> > >
> > > monir wrote:
> > > >
> > > > 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.
> > > >
> > > > "Dave Peterson" wrote:
> > > >
> > > > > 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.)
> > > > >
> > > > > monir wrote:
> > > > > >
> > > > > > 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.
> > > > > >
> > > > > > "Dave Peterson" wrote:
> > > > > >
> > > > > > > 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.)
> > > > > > >
> > > > > > > monir wrote:
> > > > > > > >
> > > > > > > > How do I suppress jiggling / pulsating Excel screen, mouse pointer, task bar
> > > > > > > > Ready, etc. ??
> > > > > > >
> > > > > > > --
> > > > > > >
> > > > > > > Dave Peterson
> > > > > > >
> > > > >
> > > > > --
> > > > >
> > > > > Dave Peterson
> > > > >
> > >
> > > --
> > >
> > > Dave Peterson
> > >
>
> --
>
> Dave Peterson
>

[Dave Peterson]

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.



monir wrote:
>
> 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.
>
> "Dave Peterson" wrote:
>
> > 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.
> >
> >
> >
> > monir wrote:
> > >
> > > 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.
> > >
> > >
> > > "Dave Peterson" wrote:
> > >
> > > > 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/microsof...ic.excel.setup
> > > > news://msnews.microsoft.com/microsoft.public.excel.misc
> > > > news://msnews.microsoft.com/microsof...heet.functions
> > > > news://msnews.microsoft.com/microsof...excel.newusers
> > > > news://msnews.microsoft.com/microsof...el.programming
> > > >
> > > > (and a few more for MSWord)
> > > > news://msnews.microsoft.com/microsof....docmanagement
> > > > news://msnews.microsoft.com/microsof...word.word97vba
> > > > news://msnews.microsoft.com/microsof....word.newusers
> > > > news://msnews.microsoft.com/microsof...ord.pagelayout
> > > > news://msnews.microsoft.com/microsof...ord.vba.addins
> > > > news://msnews.microsoft.com/microsof....vba.beginners
> > > > news://msnews.microsoft.com/microsof....customization
> > > > news://msnews.microsoft.com/microsof...rd.vba.general
> > > > news://msnews.microsoft.com/microsof....vba.userforms
> > > > news://msnews.microsoft.com/microsof....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_tut...e_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_gr...Excel*&num=100
> > > >
> > > > Ron de Bruin has an excel addin that you may like:
> > > > http://www.rondebruin.nl/Google.htm
> > > >
> > > > monir wrote:
> > > > >
> > > > > 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.
> > > > >
> > > > > "Dave Peterson" wrote:
> > > > >
> > > > > > 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.)
> > > > > >
> > > > > > monir wrote:
> > > > > > >
> > > > > > > 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.
> > > > > > >
> > > > > > > "Dave Peterson" wrote:
> > > > > > >
> > > > > > > > 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.)
> > > > > > > >
> > > > > > > > monir wrote:
> > > > > > > > >
> > > > > > > > > How do I suppress jiggling / pulsating Excel screen, mouse pointer, task bar
> > > > > > > > > Ready, etc. ??
> > > > > > > >
> > > > > > > > --
> > > > > > > >
> > > > > > > > Dave Peterson
> > > > > > > >
> > > > > >
> > > > > > --
> > > > > >
> > > > > > Dave Peterson
> > > > > >
> > > >
> > > > --
> > > >
> > > > Dave Peterson
> > > >
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson