| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel 2003 / Windows XP Pulsating Excel screen !!
How do I suppress jiggling / pulsating Excel screen, mouse pointer, task bar
Ready, etc. ?? |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
|
#5
|
|||
|
|||
|
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 |
|
#6
|
|||
|
|||
|
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 |
|
#7
|
|||
|
|||
|
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 |
|
#8
|
|||
|
|||
|
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 |
|
#9
|
|||
|
|||
|
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 |
|
#10
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Opening DBF files with Excel 2003 via Windows Explorer ? | Setting up and Configuration of Excel | |||
| Open two excel windows side by side | Excel Discussion (Misc queries) | |||
| sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
| Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) | |||
Linear Mode
