MattDaddyRamos
New Member
- Joined
- Sep 11, 2013
- Messages
- 45
Hi All,
I know there are several thread about this topic but all of them are above my experience and I need someone to dumb it down for me. I am trying to write a macro in an Excel workbook that makes my mouse move to prevent my laptop from timing out. I know about the settings to do so, but I am looking for an Excel macro for a specific reason.
Here is what I need, and please forgive me if I sound elementary with this. Just humor me.
I've given this 3+ hours of trial and error and used the threads on several message boards but I can't seem to get it to work perfectly & keep getting errors. I am a newby at VBA so please explain what is being done so that I may learn from your wisdom.
Thanks in advance for bringing this script down to the toddler level for me.
And for your patience in doing so. I WILL get this [eventually]!
Matt
I know there are several thread about this topic but all of them are above my experience and I need someone to dumb it down for me. I am trying to write a macro in an Excel workbook that makes my mouse move to prevent my laptop from timing out. I know about the settings to do so, but I am looking for an Excel macro for a specific reason.
Here is what I need, and please forgive me if I sound elementary with this. Just humor me.
- I have Excel 2007, I know how to record a macro while I am doing the steps, but what are the steps to write (or paste) a macro without having to record the steps?
- I need someone to write the macro without any extra words or blanks for me to fill in. I just want to copy & paste please.
- I need it to make the mouse curser move enough to "reset the time out timer thingy".
- I need it to repeat every minute and automatically stop (so that it can time out) after X (adjustable amount of time) or X number of times (minutes), whichever is easiest for you.
- Name it, word it, build it however, just tell me how to make it work on my sheet and dont leave anything for me to do other than copy & paste PLEASE.
I've given this 3+ hours of trial and error and used the threads on several message boards but I can't seem to get it to work perfectly & keep getting errors. I am a newby at VBA so please explain what is being done so that I may learn from your wisdom.
Thanks in advance for bringing this script down to the toddler level for me.

Matt